APPS.OE_RETROBILL_PVT dependencies on OE_PRICE_ADJ_ASSOCS

Line 2676: INSERT INTO OE_PRICE_ADJ_ASSOCS

2672: IF l_debug_level > 0 THEN
2673: oe_debug_pub.add( 'pviprana INSERTED '||SQL%ROWCOUNT||' NEW ADJUSTMENTS' ) ;
2674: END IF;
2675:
2676: INSERT INTO OE_PRICE_ADJ_ASSOCS
2677: ( PRICE_ADJUSTMENT_ID
2678: ,CREATION_DATE
2679: ,CREATED_BY
2680: ,LAST_UPDATE_DATE

Line 2703: ,OE_PRICE_ADJ_ASSOCS_S.nextval

2699: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
2700: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_ID
2701: ,NULL --p_Line_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
2702: ,NULL --p_Line_Adj_Assoc_Rec.REQUEST_ID
2703: ,OE_PRICE_ADJ_ASSOCS_S.nextval
2704: ,NULL
2705: ,RLDET.PRICE_ADJUSTMENT_ID
2706: ,1
2707: FROM

Line 2726: FROM OE_PRICE_ADJ_ASSOCS

2722: nvl(RLDET.AUTOMATIC_FLAG, 'N') = 'Y' AND
2723: -- not in might not be needed
2724: RLDET.PRICE_ADJUSTMENT_ID
2725: NOT IN (SELECT RLTD_PRICE_ADJ_ID
2726: FROM OE_PRICE_ADJ_ASSOCS
2727: WHERE PRICE_ADJUSTMENT_ID = LDET.PRICE_ADJUSTMENT_ID ) AND
2728: RLTD.PRICING_STATUS_CODE = 'N');
2729:
2730: