APPS.ONT_OEXOEIOS_XMLP_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 337: AR_PAYMENT_SCHEDULES

333: SELECT
334: MAX(TERMS_SEQUENCE_NUMBER)
335: INTO L_TERMS_SEQUANCE_NUMBER
336: FROM
337: AR_PAYMENT_SCHEDULES
338: WHERE CUSTOMER_TRX_ID = TRX_ID;
339: IF L_TERMS_SEQUANCE_NUMBER IS NULL THEN
340: SELECT
341: SUM(PS.AMOUNT_DUE_ORIGINAL),

Line 346: AR_PAYMENT_SCHEDULES PS

342: SUM(PS.AMOUNT_DUE_ORIGINAL - PS.AMOUNT_DUE_REMAINING),
343: SUM(PS.AMOUNT_DUE_REMAINING)
344: INTO L_AMOUNT,L_CREDIT_AMOUNT,L_BALANCE_DUE
345: FROM
346: AR_PAYMENT_SCHEDULES PS
347: WHERE PS.CUSTOMER_TRX_ID = TRX_ID;
348: ELSE
349: SELECT
350: PS.AMOUNT_DUE_ORIGINAL,

Line 355: AR_PAYMENT_SCHEDULES PS

351: ( PS.AMOUNT_DUE_ORIGINAL - PS.AMOUNT_DUE_REMAINING ),
352: PS.AMOUNT_DUE_REMAINING
353: INTO L_AMOUNT,L_CREDIT_AMOUNT,L_BALANCE_DUE
354: FROM
355: AR_PAYMENT_SCHEDULES PS
356: WHERE PS.CUSTOMER_TRX_ID = TRX_ID
357: AND PS.TERMS_SEQUENCE_NUMBER = L_TERMS_SEQUANCE_NUMBER;
358: END IF;
359: C_AMOUNT := L_AMOUNT;