APPS.OE_ADV_PRICE_PVT dependencies on OE_PRICE_ADJ_ASSOCS

Line 2444: INSERT INTO OE_PRICE_ADJ_ASSOCS

2440: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;
2441: END IF;
2442:
2443:
2444: INSERT INTO OE_PRICE_ADJ_ASSOCS
2445: ( PRICE_ADJUSTMENT_ID
2446: ,CREATION_DATE
2447: ,CREATED_BY
2448: ,LAST_UPDATE_DATE

Line 2471: ,OE_PRICE_ADJ_ASSOCS_S.nextval

2467: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2468: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2469: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
2470: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
2471: ,OE_PRICE_ADJ_ASSOCS_S.nextval
2472: ,NULL
2473: ,RLDET.PRICE_ADJUSTMENT_ID
2474: ,1
2475: FROM

Line 2495: FROM OE_PRICE_ADJ_ASSOCS

2491: nvl(RLDET.AUTOMATIC_FLAG, 'N') = 'Y' AND
2492: -- not in might not be needed
2493: RLDET.PRICE_ADJUSTMENT_ID
2494: NOT IN (SELECT RLTD_PRICE_ADJ_ID
2495: FROM OE_PRICE_ADJ_ASSOCS
2496: WHERE PRICE_ADJUSTMENT_ID = LDET.PRICE_ADJUSTMENT_ID ) AND
2497: RLTD.PRICING_STATUS_CODE = 'N'
2498: AND RLINE.LINE_INDEX = RLDET.LINE_INDEX
2499: AND RLINE.PROCESS_STATUS <> 'NOT_VALID' );