DBA Data[Home] [Help]

APPS.AP_APXKIRKI_XMLP_PKG dependencies on AP_INVOICE_PAYMENTS

Line 637: AP_INVOICE_PAYMENTS PAY

633: ,0)
634: INTO L_TOTAL_PAID_INV,L_TOTAL_DISCS_DLR,L_TOTAL_DISCS
635: FROM
636: AP_CHECKS CHK,
637: AP_INVOICE_PAYMENTS PAY
638: WHERE CHECK_DATE <= TO_DATE(C_END_DATE
639: ,'DD/MM/YYYY')
640: AND PAY.CHECK_ID = CHK.CHECK_ID
641: AND NVL(VOID_DATE

Line 1091: AP_INVOICE_PAYMENTS PAY

1087: ,0)
1088: INTO L_MANUAL_PAYMENTS,L_MANUAL_PAYMENTS_DLR,L_AUTO_PAYMENTS,L_AUTO_PAYMENTS_DLR,L_INVOICES,L_DISCOUNT_DLR,L_DISCOUNTS
1089: FROM
1090: AP_CHECKS CHK,
1091: AP_INVOICE_PAYMENTS PAY
1092: WHERE CHECK_DATE >= TO_DATE(C_START_DATE
1093: ,'DD/MM/YYYY')
1094: AND CHECK_DATE <= TO_DATE(C_END_DATE
1095: ,'DD/MM/YYYY')