APPS.OE_LINE_PRICE_AATTR_UTIL dependencies on OE_PRICE_ADJ_ASSOCS

Line 304: FROM OE_PRICE_ADJ_ASSOCS ASSOCS,

300: --bug3528335 splitting the DELETE statement to delete attributes corresponding to child lines first (if the parent is PBH) and then the 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');