APPS.FV_CCR_UTIL_PVT dependencies on PO_VENDOR_SITES_ALL

Line 221: --po_vendor_sites_all

217:
218:
219: CURSOR site_code_dup_csr(p_supp_id NUMBER,p_site_name VARCHAR2,p_org NUMBER) IS
220: --SELECT vendor_site_id,duns_number FROM
221: --po_vendor_sites_all
222: --WHERE vendor_id=p_supp_id
223: --AND vendor_site_code=p_site_name
224: --AND org_id=p_org;
225: SELECT pavs.vendor_site_id, hps.duns_number_c

Line 259: --FROM po_vendor_sites_all

255: l_module_name VARCHAR2(60);
256: BEGIN
257: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_vendor_site_code';
258: SELECT vendor_site_code INTO x_site_code
259: --FROM po_vendor_sites_all
260: FROM ap_supplier_sites_all
261: WHERE vendor_site_id = p_vendor_site_id;
262: EXCEPTION
263: WHEN OTHERS THEN

Line 2083: from fv_ccr_orgs o, hr_organization_units ou, po_vendor_sites_all vs

2079:
2080: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
2081: IF p_org_id is NOT NULL THEN
2082: for crec in (select main_address_site_id
2083: from fv_ccr_orgs o, hr_organization_units ou, po_vendor_sites_all vs
2084: where o.main_address_site_id is not null
2085: and o.main_address_site_flag = 'Y'
2086: and o.main_address_site_id = vs.VENDOR_SITE_ID
2087: and vs.ORG_ID = ou.organization_id