APPS.FV_CCR_UTIL_PVT dependencies on PO_VENDOR_SITES_ALL

Line 218: --po_vendor_sites_all

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

Line 256: --FROM po_vendor_sites_all

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

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

1858:
1859: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
1860: IF p_org_id is NOT NULL THEN
1861: for crec in (select main_address_site_id
1862: from fv_ccr_orgs o, hr_organization_units ou, po_vendor_sites_all vs
1863: where o.main_address_site_id is not null
1864: and o.main_address_site_flag = 'Y'
1865: and o.main_address_site_id = vs.VENDOR_SITE_ID
1866: and vs.ORG_ID = ou.organization_id