APPS.OE_RMA_LINE_VALIDATE dependencies on SO_PRICE_ADJUSTMENTS_S

Line 258: SELECT SO_PRICE_ADJUSTMENTS_S.NEXTVAL

254: , ATTRIBUTE14
255: , ATTRIBUTE15
256: , CONTEXT
257: )
258: SELECT SO_PRICE_ADJUSTMENTS_S.NEXTVAL
259: , SYSDATE
260: , L_USER_ID
261: , SYSDATE
262: , L_USER_ID

Line 291: FROM SO_PRICE_ADJUSTMENTS SPA

287: WHERE SO_PRICE_ADJUSTMENTS.HEADER_ID = L_REFERENCE_ORDER_HEADER_ID
288: AND NVL(SO_PRICE_ADJUSTMENTS.LINE_ID,L_LINK_TO_LINE_ID) =
289: L_LINK_TO_LINE_ID
290: AND NOT EXISTS (SELECT 'HEADER LEVEL DISCOUNT ALREADY EXISTS'
291: FROM SO_PRICE_ADJUSTMENTS SPA
292: WHERE SPA.DISCOUNT_ID = SO_PRICE_ADJUSTMENTS.DISCOUNT_ID
293: AND SPA.HEADER_ID = L_HEADER_ID
294: AND SPA.LINE_ID IS NULL);
295: