DBA Data[Home] [Help]

APPS.OE_LINE_PRICE_AATTR_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 305: OE_PRICE_ADJUSTMENTS PARENT

301: --bug3405372 deleting the rows corresponding to the child lines of PBH modifiers as well.
302: DELETE FROM OE_PRICE_ADJ_ATTRIBS
303: WHERE PRICE_ADJUSTMENT_ID IN (SELECT RLTD_PRICE_ADJ_ID
304: FROM OE_PRICE_ADJ_ASSOCS ASSOCS,
305: OE_PRICE_ADJUSTMENTS PARENT
306: WHERE ASSOCS.PRICE_ADJUSTMENT_ID=PARENT.PRICE_ADJUSTMENT_ID
307: AND PARENT.PRICE_ADJUSTMENT_ID=p_price_adjustment_id
308: AND PARENT.LIST_LINE_TYPE_CODE='PBH');
309: IF l_debug_level > 0 THEN