APPS.OE_RETROBILL_PVT dependencies on OE_PRICE_ADJ_ASSOCS

Line 2338: INSERT INTO OE_PRICE_ADJ_ASSOCS

2334: IF l_debug_level > 0 THEN
2335: oe_debug_pub.add( 'pviprana INSERTED '||SQL%ROWCOUNT||' NEW ADJUSTMENTS' ) ;
2336: END IF;
2337:
2338: INSERT INTO OE_PRICE_ADJ_ASSOCS
2339: ( PRICE_ADJUSTMENT_ID
2340: ,CREATION_DATE
2341: ,CREATED_BY
2342: ,LAST_UPDATE_DATE

Line 2365: ,OE_PRICE_ADJ_ASSOCS_S.nextval

2361: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2362: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2363: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
2364: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
2365: ,OE_PRICE_ADJ_ASSOCS_S.nextval
2366: ,NULL
2367: ,RLDET.PRICE_ADJUSTMENT_ID
2368: ,1
2369: FROM

Line 2388: FROM OE_PRICE_ADJ_ASSOCS

2384: nvl(RLDET.AUTOMATIC_FLAG, 'N') = 'Y' AND
2385: -- not in might not be needed
2386: RLDET.PRICE_ADJUSTMENT_ID
2387: NOT IN (SELECT RLTD_PRICE_ADJ_ID
2388: FROM OE_PRICE_ADJ_ASSOCS
2389: WHERE PRICE_ADJUSTMENT_ID = LDET.PRICE_ADJUSTMENT_ID ) AND
2390: RLTD.PRICING_STATUS_CODE = 'N');
2391:
2392: