APPS.OE_BULK_PRICEORDER_PVT dependencies on OE_PRICE_ADJ_ASSOCS

Line 403: INSERT INTO OE_PRICE_ADJ_ASSOCS

399: END IF;
400:
401: --Insert associations
402:
403: INSERT INTO OE_PRICE_ADJ_ASSOCS
404: ( PRICE_ADJUSTMENT_ID
405: ,CREATION_DATE
406: ,CREATED_BY
407: ,LAST_UPDATE_DATE

Line 430: ,OE_PRICE_ADJ_ASSOCS_S.nextval

426: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
427: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
428: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
429: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
430: ,OE_PRICE_ADJ_ASSOCS_S.nextval
431: ,NULL
432: ,RLDET.PRICE_ADJUSTMENT_ID
433: ,1
434: FROM

Line 453: FROM OE_PRICE_ADJ_ASSOCS

449: nvl(RLDET.AUTOMATIC_FLAG, 'N') = 'Y' AND
450: -- not in might not be needed
451: RLDET.PRICE_ADJUSTMENT_ID
452: NOT IN (SELECT RLTD_PRICE_ADJ_ID
453: FROM OE_PRICE_ADJ_ASSOCS
454: WHERE PRICE_ADJUSTMENT_ID = LDET.PRICE_ADJUSTMENT_ID ) AND
455: RLTD.PRICING_STATUS_CODE = 'N');
456:
457: --Insert pricing attributes