DBA Data[Home] [Help]

APPS.AP_APXKIRKI_XMLP_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 647: AP_PAYMENT_SCHEDULES PAY,

643: SELECT
644: count(*)
645: INTO L_TOTAL_SCHEDULED
646: FROM
647: AP_PAYMENT_SCHEDULES PAY,
648: AP_INVOICES INV
649: WHERE PAY.INVOICE_ID = INV.INVOICE_ID
650: AND TRUNC(INV.CREATION_DATE) <= TO_DATE(C_END_DATE
651: ,'DD/MM/YYYY');

Line 1142: AP_PAYMENT_SCHEDULES PAY,

1138: SELECT
1139: count(*)
1140: INTO L_PAYMENT_SCHEDULES
1141: FROM
1142: AP_PAYMENT_SCHEDULES PAY,
1143: AP_INVOICES INV
1144: WHERE PAY.INVOICE_ID = INV.INVOICE_ID
1145: AND TRUNC(INV.CREATION_DATE) >= TO_DATE(C_START_DATE
1146: ,'DD/MM/YYYY')