APPS.AP_IMPORT_UTILITIES_PKG dependencies on PO_VENDOR_SITES

Line 1816: -- Get tolerance info. from po_vendor_sites_all

1812:
1813: -- Bug 4051803
1814: --===================================================================
1815: -- Function: get_tolerance_info
1816: -- Get tolerance info. from po_vendor_sites_all
1817: -- based on vendor_site_id
1818: --===================================================================
1819: FUNCTION get_tolerance_info(
1820: p_vendor_site_id IN NUMBER,

Line 1877: po_vendor_sites_all pvs

1873: p_goods_ship_amt_tolerance,
1874: p_goods_rate_amt_tolerance,
1875: p_goods_total_amt_tolerance
1876: from ap_tolerance_templates att,
1877: po_vendor_sites_all pvs
1878: where pvs.vendor_site_id = p_vendor_site_id
1879: and pvs.tolerance_id = att.tolerance_id;
1880:
1881: EXCEPTION

Line 1907: po_vendor_sites_all pvs

1903: p_services_ship_amt_tolerance,
1904: p_services_rate_amt_tolerance,
1905: p_services_total_amt_tolerance
1906: from ap_tolerance_templates att,
1907: po_vendor_sites_all pvs
1908: where pvs.vendor_site_id = p_vendor_site_id
1909: and pvs.services_tolerance_id = att.tolerance_id;
1910:
1911:

Line 1979: FROM po_vendor_sites PVS

1975: IS
1976:
1977: CURSOR primary_pay_site_cur IS
1978: SELECT vendor_site_id
1979: FROM po_vendor_sites PVS
1980: WHERE vendor_id = p_vendor_id
1981: AND pay_site_flag = 'Y'
1982: AND primary_pay_site_flag = 'Y'
1983: AND NVL(trunc(PVS.INACTIVE_DATE),AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)

Line 1988: FROM po_vendor_sites PVS

1984: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;
1985:
1986: CURSOR pay_site_cur IS
1987: SELECT vendor_site_id
1988: FROM po_vendor_sites PVS
1989: WHERE vendor_id = p_vendor_id
1990: AND pay_site_flag = 'Y'
1991: AND NVL(trunc(PVS.INACTIVE_DATE),AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
1992: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;

Line 1994: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;

1990: AND pay_site_flag = 'Y'
1991: AND NVL(trunc(PVS.INACTIVE_DATE),AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
1992: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;
1993:
1994: l_vendor_site_id PO_VENDOR_SITES.VENDOR_SITE_ID%TYPE;
1995: l_paysite_count NUMBER;
1996: current_calling_sequence VARCHAR2(2000);
1997: debug_info VARCHAR2(500);
1998:

Line 2019: FROM po_vendor_sites PVS

2015: IF ( l_vendor_site_id is null ) THEN
2016:
2017: SELECT count(*)
2018: INTO l_paysite_count
2019: FROM po_vendor_sites PVS
2020: WHERE vendor_id = p_vendor_id
2021: AND pay_site_flag = 'Y'
2022: AND NVL(trunc(PVS.INACTIVE_DATE),AP_IMPORT_INVOICES_PKG.g_inv_sysdate+1)
2023: > AP_IMPORT_INVOICES_PKG.g_inv_sysdate ;