APPS.OE_HEADER_PATTR_UTIL dependencies on OE_PRICE_ADJ_ASSOCS

Line 2708: (select rltd_price_adj_id from oe_price_adj_assocs where

2704: if l_lst_code in ('PRG','IUE','OID') then
2705: null; --do not expect these cases to be overriden
2706: elsif l_lst_code = 'PBH' then
2707: delete from oe_price_adjustments where price_adjustment_id in
2708: (select rltd_price_adj_id from oe_price_adj_assocs where
2709: price_adjustment_id = l_prc_adj_id
2710: union
2711: select price_adjustment_id from oe_price_adj_assocs where
2712: price_adjustment_id = l_prc_adj_id

Line 2711: select price_adjustment_id from oe_price_adj_assocs where

2707: delete from oe_price_adjustments where price_adjustment_id in
2708: (select rltd_price_adj_id from oe_price_adj_assocs where
2709: price_adjustment_id = l_prc_adj_id
2710: union
2711: select price_adjustment_id from oe_price_adj_assocs where
2712: price_adjustment_id = l_prc_adj_id
2713: );
2714: delete from oe_price_adj_assocs where
2715: price_adjustment_id = l_prc_adj_id;

Line 2714: delete from oe_price_adj_assocs where

2710: union
2711: select price_adjustment_id from oe_price_adj_assocs where
2712: price_adjustment_id = l_prc_adj_id
2713: );
2714: delete from oe_price_adj_assocs where
2715: price_adjustment_id = l_prc_adj_id;
2716: elsif l_lst_code in ('DIS','SUR') then
2717: begin
2718: --check if this is freegoods lines adjustment if so, do not delete

Line 2720: from oe_price_adj_assocs opaa,oe_price_adjustments opa

2716: elsif l_lst_code in ('DIS','SUR') then
2717: begin
2718: --check if this is freegoods lines adjustment if so, do not delete
2719: select 1 into l_tmp1
2720: from oe_price_adj_assocs opaa,oe_price_adjustments opa
2721: where opaa.rltd_price_adj_id = l_prc_adj_id and
2722: opaa.price_adjustment_id = opa.price_adjustment_id and
2723: opa.list_line_type_code = 'PRG';
2724: exception