APPS.AP_WEB_AUDIT_UTILS dependencies on AP_INVOICES_ALL

Line 1803: FROM ap_invoices_all i,

1799:
1800: CURSOR advance_cur(p_default_currency_code IN VARCHAR2) IS
1801: SELECT get_available_prepays(vdr.vendor_id) advance_count,
1802: aerh.employee_id
1803: FROM ap_invoices_all i,
1804: ap_expense_report_headers_all aerh,
1805: ap_suppliers vdr
1806: WHERE i.vendor_id = vdr.vendor_id
1807: AND aerh.report_header_id = p_report_header_id

Line 1825: FROM ap_invoices_all i, ap_suppliers vdr

1821: GROUP BY aerh.employee_id;
1822:
1823: CURSOR remaining_cur(p_employee_id NUMBER, p_default_currency_code IN VARCHAR2) IS
1824: SELECT nvl(sum( get_prepay_amount_remaining(i.invoice_id) ), 0) remaining_prepayment
1825: FROM ap_invoices_all i, ap_suppliers vdr
1826: WHERE i.vendor_id = vdr.vendor_id
1827: AND vdr.employee_id = p_employee_id
1828: AND i.invoice_type_lookup_code||'' = 'PREPAYMENT'
1829: AND i.earliest_settlement_date IS NOT NULL

Line 2982: AP_INVOICES_ALL AI,

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

Line 2992: from AP_INVOICES_ALL AI,

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

Line 3153: FROM ap_invoices_all ai

3149: 1,0,
3150: 1),
3151: 0))
3152: INTO prepay_count
3153: FROM ap_invoices_all ai
3154: WHERE vendor_id = l_vendor_id
3155: AND invoice_type_lookup_code = 'PREPAYMENT'
3156: AND earliest_settlement_date IS NOT NULL
3157: AND get_prepay_amount_remaining(ai.invoice_id) > 0;