APPS.OE_SALES_CAN_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 1302: from oe_price_adjustments opa1,

1298: /* Fix for bug # 2387919 */
1299: begin
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

Line 1303: oe_price_adjustments opa2,

1299: begin
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

Line 1934: from oe_price_adjustments opa1,

1930: /* Fix for bug # 2387919 */
1931: begin
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'

Line 1935: oe_price_adjustments opa2,

1931: begin
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