DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 2983: AP_PAYMENT_SCHEDULES_ALL APS

2979: APS.GROSS_AMOUNT,
2980: AI.CANCELLED_DATE
2981: from ap_expense_report_headers_all aerh,
2982: AP_INVOICES_ALL AI,
2983: AP_PAYMENT_SCHEDULES_ALL APS
2984: where AI.INVOICE_ID(+) = AERH.VOUCHNO
2985: and APS.INVOICE_ID(+) = AI.INVOICE_ID
2986: and aerh.report_header_id = p_report_header_id;
2987:

Line 2993: AP_PAYMENT_SCHEDULES_ALL APS

2989: SELECT AI.Payment_status_flag,
2990: APS.GROSS_AMOUNT,
2991: AI.CANCELLED_DATE
2992: from AP_INVOICES_ALL AI,
2993: AP_PAYMENT_SCHEDULES_ALL APS
2994: where AI.INVOICE_ID= APS.INVOICE_ID
2995: AND AI.INVOICE_ID = p_invoice_id;
2996:
2997: status_rec status_cur%ROWTYPE;