71:
72: cursor prg_parent(c_line_id number)
73: is
74: select opa1.line_id
75: from oe_price_adjustments opa1,
76: oe_price_adjustments opa2,
77: oe_price_adj_assocs opaa
78: where opa1.list_line_type_code = 'PRG'
79: and opa1.price_adjustment_id = opaa.price_adjustment_id
72: cursor prg_parent(c_line_id number)
73: is
74: select opa1.line_id
75: from oe_price_adjustments opa1,
76: oe_price_adjustments opa2,
77: oe_price_adj_assocs opaa
78: where opa1.list_line_type_code = 'PRG'
79: and opa1.price_adjustment_id = opaa.price_adjustment_id
80: and opa2.price_adjustment_id = opaa.rltd_price_adj_id