SQL & PL/SQL

Hi Friends,

I am getting the following error -

Error:
ORA - 06550: line 74,column11:
PL/SQL:ORA - 00920:invalid relational operator.

The code is here for your reference -

DECLARE
TYPE cur_typ
IS
REF
CURSOR;
c cur_typ;
query_str VARCHAR2(4000);
v_part_num VARCHAR2(40);
v_customer_name VARCHAR2(30);
v_op_name VARCHAR2(3200);
CURSOR c1(p_opr_unit varchar2)
IS
SELECT partno part_num ,
customer customer_name ,
hou.name op_name
FROM hr_organization_units hou,
oe_transaction_types_all sot ,
ra_customers rc ,
ra_addresses_all ra ,
ra_site_uses_all rsu ,
oe_order_headers_all h ,
oe_order_lines_all l ,
pwr_sod50 ps
WHERE '''''
|| ',||'
|| ''''
|| ' :id1 '
|| ''''
|| '||,'
|| ''''
|| ' like '
|| ''''
|| '%,'
|| ''''
|| ''''
|| ''''
|| ' hou.name '
|| ''''
|| ''''
|| ''''
|| ',%'
|| ''''
|| '
AND ps.group_id = 9999999
AND hou.organization_id=h.org_id
AND ps.line_id =l.line_id
AND l.header_id =h.header_id
AND h.invoice_to_org_id=rsu.site_use_id
AND rsu.address_id =ra.address_id
AND ra.customer_id =rc.customer_id
AND h.order_type_id =sot.transaction_type_id ;
BEGIN
open c1(v_op_name) ;
LOOP
FETCH c1
INTO v_part_num ,
v_customer_name ,
v_op_name;
EXIT WHEN c1%NOTFOUND;
END LOOP;
CLOSE c1;
END;


Thanks In Advance!
Ramya Nomula