DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on AP_SUPPLIERS

Line 1780: FROM ap_suppliers vdr,

1776: FUNCTION get_advance_exists(p_report_header_id IN NUMBER) RETURN VARCHAR2 IS
1777:
1778: CURSOR site_cur IS
1779: SELECT site.invoice_currency_code default_currency_code
1780: FROM ap_suppliers vdr,
1781: ap_supplier_sites_all site,
1782: ap_expense_report_headers_all aerh,
1783: financials_system_params_all fp
1784: WHERE aerh.report_header_id = p_report_header_id

Line 1793: FROM ap_suppliers vdr,

1789: AND upper(site.vendor_site_code) = UPPER(AP_WEB_POLICY_UTILS.get_lookup_meaning('HOME_OFFICE', fp.expense_check_address_flag));
1790:
1791: CURSOR vendor_cur IS
1792: SELECT nvl(vdr.invoice_currency_code,sp.base_currency_code) default_currency_code
1793: FROM ap_suppliers vdr,
1794: ap_expense_report_headers_all aerh,
1795: ap_system_parameters_all sp
1796: WHERE vdr.employee_id = aerh.employee_id
1797: AND aerh.report_header_id = p_report_header_id

Line 1805: ap_suppliers vdr

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