APPS.AP_WEB_AUDIT_UTILS dependencies on AP_INVOICES_ALL

Line 1761: FROM ap_invoices_all i,

1757:
1758: CURSOR advance_cur(p_default_currency_code IN VARCHAR2) IS
1759: SELECT get_available_prepays(vdr.vendor_id) advance_count,
1760: aerh.employee_id
1761: FROM ap_invoices_all i,
1762: ap_expense_report_headers_all aerh,
1763: ap_suppliers vdr
1764: WHERE i.vendor_id = vdr.vendor_id
1765: AND aerh.report_header_id = p_report_header_id

Line 1783: FROM ap_invoices_all i, ap_suppliers vdr

1779: GROUP BY aerh.employee_id;
1780:
1781: CURSOR remaining_cur(p_employee_id NUMBER, p_default_currency_code IN VARCHAR2) IS
1782: SELECT nvl(sum( get_prepay_amount_remaining(i.invoice_id) ), 0) remaining_prepayment
1783: FROM ap_invoices_all i, ap_suppliers vdr
1784: WHERE i.vendor_id = vdr.vendor_id
1785: AND vdr.employee_id = p_employee_id
1786: AND i.invoice_type_lookup_code||'' = 'PREPAYMENT'
1787: AND i.earliest_settlement_date IS NOT NULL

Line 2933: AP_INVOICES_ALL AI,

2929: AI.Payment_status_flag,
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;

Line 2943: from AP_INVOICES_ALL AI,

2939: CURSOR invoice_cur IS
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:

Line 3104: FROM ap_invoices_all ai

3100: 1,0,
3101: 1),
3102: 0))
3103: INTO prepay_count
3104: FROM ap_invoices_all ai
3105: WHERE vendor_id = l_vendor_id
3106: AND invoice_type_lookup_code = 'PREPAYMENT'
3107: AND earliest_settlement_date IS NOT NULL
3108: AND get_prepay_amount_remaining(ai.invoice_id) > 0;