APPS.OE_ADV_PRICE_PVT dependencies on OE_PRICE_ADJ_ASSOCS

Line 2917: INSERT INTO OE_PRICE_ADJ_ASSOCS

2913: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;
2914: END IF;
2915:
2916:
2917: INSERT INTO OE_PRICE_ADJ_ASSOCS
2918: ( PRICE_ADJUSTMENT_ID
2919: ,CREATION_DATE
2920: ,CREATED_BY
2921: ,LAST_UPDATE_DATE

Line 2944: ,OE_PRICE_ADJ_ASSOCS_S.nextval

2940: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2941: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2942: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
2943: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
2944: ,OE_PRICE_ADJ_ASSOCS_S.nextval
2945: ,NULL
2946: ,RLDET.PRICE_ADJUSTMENT_ID
2947: ,1
2948: FROM

Line 2971: FROM OE_PRICE_ADJ_ASSOCS

2967: nvl(RLDET.AUTOMATIC_FLAG, 'N') = 'Y' AND
2968: -- not in might not be needed
2969: RLDET.PRICE_ADJUSTMENT_ID
2970: NOT IN (SELECT RLTD_PRICE_ADJ_ID
2971: FROM OE_PRICE_ADJ_ASSOCS
2972: WHERE PRICE_ADJUSTMENT_ID = LDET.PRICE_ADJUSTMENT_ID ) AND
2973: RLTD.PRICING_STATUS_CODE = 'N'
2974: AND RLINE.LINE_INDEX = RLDET.LINE_INDEX
2975: AND RLINE.PROCESS_STATUS <> 'NOT_VALID' );