DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 2934: AP_PAYMENT_SCHEDULES_ALL APS

2930: APS.GROSS_AMOUNT,
2931: AI.CANCELLED_DATE
2932: from ap_expense_report_headers_all aerh,
2933: AP_INVOICES_ALL AI,
2934: AP_PAYMENT_SCHEDULES_ALL APS
2935: where AI.INVOICE_ID(+) = AERH.VOUCHNO
2936: and APS.INVOICE_ID(+) = AI.INVOICE_ID
2937: and aerh.report_header_id = p_report_header_id;
2938:

Line 2944: AP_PAYMENT_SCHEDULES_ALL APS

2940: SELECT AI.Payment_status_flag,
2941: APS.GROSS_AMOUNT,
2942: AI.CANCELLED_DATE
2943: from AP_INVOICES_ALL AI,
2944: AP_PAYMENT_SCHEDULES_ALL APS
2945: where AI.INVOICE_ID= APS.INVOICE_ID
2946: AND AI.INVOICE_ID = p_invoice_id;
2947:
2948: status_rec status_cur%ROWTYPE;