APPS.OE_LINE_PATTR_UTIL dependencies on OE_PRICE_ADJ_ASSOCS

Line 3225: (select rltd_price_adj_id from oe_price_adj_assocs where

3221: if l_lst_code in ('PRG','IUE','OID') then
3222: null; --do not expect these cases to be overriden
3223: elsif l_lst_code = 'PBH' then
3224: delete from oe_price_adjustments where price_adjustment_id in
3225: (select rltd_price_adj_id from oe_price_adj_assocs where
3226: price_adjustment_id = l_prc_adj_id
3227: union
3228: select price_adjustment_id from oe_price_adj_assocs where
3229: price_adjustment_id = l_prc_adj_id

Line 3228: select price_adjustment_id from oe_price_adj_assocs where

3224: delete from oe_price_adjustments where price_adjustment_id in
3225: (select rltd_price_adj_id from oe_price_adj_assocs where
3226: price_adjustment_id = l_prc_adj_id
3227: union
3228: select price_adjustment_id from oe_price_adj_assocs where
3229: price_adjustment_id = l_prc_adj_id
3230: );
3231: delete from oe_price_adj_assocs where
3232: price_adjustment_id = l_prc_adj_id;

Line 3231: delete from oe_price_adj_assocs where

3227: union
3228: select price_adjustment_id from oe_price_adj_assocs where
3229: price_adjustment_id = l_prc_adj_id
3230: );
3231: delete from oe_price_adj_assocs where
3232: price_adjustment_id = l_prc_adj_id;
3233: elsif l_lst_code in ('DIS','SUR') then
3234: begin
3235: --check if this is a freegoods lines adjustment if so, do not delete it

Line 3237: from oe_price_adj_assocs opaa,oe_price_adjustments opa

3233: elsif l_lst_code in ('DIS','SUR') then
3234: begin
3235: --check if this is a freegoods lines adjustment if so, do not delete it
3236: select 1 into l_tmp1
3237: from oe_price_adj_assocs opaa,oe_price_adjustments opa
3238: where opaa.rltd_price_adj_id = l_prc_adj_id and
3239: opaa.price_adjustment_id = opa.price_adjustment_id and
3240: opa.list_line_type_code = 'PRG';
3241: exception