DBA Data[Home] [Help]

APPS.AP_WEB_OA_ACTIVE_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 571: AP_PAYMENT_SCHEDULES_ALL APS

567: INTO l_final_status_code
568: FROM
569: AP_INVOICES_ALL AI,
570: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
571: AP_PAYMENT_SCHEDULES_ALL APS
572: WHERE AERH.VOUCHNO = AI.INVOICE_ID
573: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id
574: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'
575: AND AI.INVOICE_ID= APS.INVOICE_ID

Line 598: AP_PAYMENT_SCHEDULES_ALL APS

594: INTO l_cc_report_status_code
595: FROM
596: AP_INVOICES_ALL AI,
597: AP_EXPENSE_REPORT_HEADERS_ALL AERH,
598: AP_PAYMENT_SCHEDULES_ALL APS
599: WHERE AERH.VOUCHNO = AI.INVOICE_ID
600: AND AERH.BOTHPAY_PARENT_ID = p_report_header_id
601: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'MIXED'
602: AND AI.INVOICE_ID= APS.INVOICE_ID