APPS.OE_SALES_CAN_UTIL dependencies on OE_PRICE_ADJ_ASSOCS

Line 1304: oe_price_adj_assocs opaa

1300: select count(*)
1301: into l_prg_line_count
1302: from oe_price_adjustments opa1,
1303: oe_price_adjustments opa2,
1304: oe_price_adj_assocs opaa
1305: where opa1.list_line_type_code = 'PRG'
1306: and opa1.price_adjustment_id = opaa.price_adjustment_id
1307: and opa2.price_adjustment_id = opaa.rltd_price_adj_id
1308: and opa2.line_id = l_line_old_tbl(j).line_id;

Line 1936: oe_price_adj_assocs opaa,

1932: select count(*)
1933: into l_prg_line_count
1934: from oe_price_adjustments opa1,
1935: oe_price_adjustments opa2,
1936: oe_price_adj_assocs opaa,
1937: oe_order_lines_all ol --bug 4156493
1938: where opa1.list_line_type_code = 'PRG'
1939: and opa1.price_adjustment_id = opaa.price_adjustment_id
1940: and opa2.price_adjustment_id = opaa.rltd_price_adj_id