DBA Data[Home] [Help]

APPS.AP_WEB_OA_ACTIVE_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 550: AP_PAYMENT_SCHEDULES_ALL APS

546: INTO l_final_status_code
547: FROM
548: AP_INVOICES_ALL AI,
549: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
550: AP_PAYMENT_SCHEDULES_ALL APS
551: WHERE AERH.VOUCHNO = AI.INVOICE_ID
552: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id
553: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'
554: AND AI.INVOICE_ID= APS.INVOICE_ID

Line 577: AP_PAYMENT_SCHEDULES_ALL APS

573: INTO l_cc_report_status_code
574: FROM
575: AP_INVOICES_ALL AI,
576: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
577: AP_PAYMENT_SCHEDULES_ALL APS
578: WHERE AERH.VOUCHNO = AI.INVOICE_ID
579: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id
580: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'
581: AND AI.INVOICE_ID= APS.INVOICE_ID