APPS.AP_WEB_AUDIT_UTILS dependencies on AP_SUPPLIERS

Line 1738: FROM ap_suppliers vdr,

1734: FUNCTION get_advance_exists(p_report_header_id IN NUMBER) RETURN VARCHAR2 IS
1735:
1736: CURSOR site_cur IS
1737: SELECT site.invoice_currency_code default_currency_code
1738: FROM ap_suppliers vdr,
1739: ap_supplier_sites_all site,
1740: ap_expense_report_headers_all aerh,
1741: financials_system_params_all fp
1742: WHERE aerh.report_header_id = p_report_header_id

Line 1751: FROM ap_suppliers vdr,

1747: AND upper(site.vendor_site_code) = UPPER(AP_WEB_POLICY_UTILS.get_lookup_meaning('HOME_OFFICE', fp.expense_check_address_flag));
1748:
1749: CURSOR vendor_cur IS
1750: SELECT nvl(vdr.invoice_currency_code,sp.base_currency_code) default_currency_code
1751: FROM ap_suppliers vdr,
1752: ap_expense_report_headers_all aerh,
1753: ap_system_parameters_all sp
1754: WHERE vdr.employee_id = aerh.employee_id
1755: AND aerh.report_header_id = p_report_header_id

Line 1763: ap_suppliers vdr

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
1766: AND vdr.employee_id = aerh.employee_id
1767: AND i.org_id = aerh.org_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