APPS.ONT_OEXOEIOS_XMLP_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 341: AR_PAYMENT_SCHEDULES

337: SELECT
338: MAX(TERMS_SEQUENCE_NUMBER)
339: INTO L_TERMS_SEQUANCE_NUMBER
340: FROM
341: AR_PAYMENT_SCHEDULES
342: WHERE CUSTOMER_TRX_ID = TRX_ID;
343: IF L_TERMS_SEQUANCE_NUMBER IS NULL THEN
344: SELECT
345: SUM(PS.AMOUNT_DUE_ORIGINAL),

Line 350: AR_PAYMENT_SCHEDULES PS

346: SUM(PS.AMOUNT_DUE_ORIGINAL - PS.AMOUNT_DUE_REMAINING),
347: SUM(PS.AMOUNT_DUE_REMAINING)
348: INTO L_AMOUNT,L_CREDIT_AMOUNT,L_BALANCE_DUE
349: FROM
350: AR_PAYMENT_SCHEDULES PS
351: WHERE PS.CUSTOMER_TRX_ID = TRX_ID;
352: ELSE
353: SELECT
354: PS.AMOUNT_DUE_ORIGINAL,

Line 359: AR_PAYMENT_SCHEDULES PS

355: ( PS.AMOUNT_DUE_ORIGINAL - PS.AMOUNT_DUE_REMAINING ),
356: PS.AMOUNT_DUE_REMAINING
357: INTO L_AMOUNT,L_CREDIT_AMOUNT,L_BALANCE_DUE
358: FROM
359: AR_PAYMENT_SCHEDULES PS
360: WHERE PS.CUSTOMER_TRX_ID = TRX_ID
361: AND PS.TERMS_SEQUENCE_NUMBER = L_TERMS_SEQUANCE_NUMBER;
362: END IF;
363: C_AMOUNT := L_AMOUNT;