16976:
16977: IF C2.line_set_id is not null THEN
16978: select distinct reference_line_id
16979: into l_ref_line_id 16980: from oe_line_sets a, 16981: oe_order_lines b
16982: where a.set_id = C2.line_set_id
16983: and a.line_id = b.line_id
16984: and b.booked_flag = 'Y'