DBA Data[Home] [Help]

APPS.OE_OE_FORM_CANCEL_LINE dependencies on OE_PRICE_ADJUSTMENTS

Line 75: from oe_price_adjustments opa1,

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

Line 76: oe_price_adjustments opa2,

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