APPS.FV_CCR_UTIL_PVT dependencies on AP_SUPPLIER_SITES_ALL

Line 223: FROM ap_supplier_sites_all pavs, hz_party_sites hps

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
223: FROM ap_supplier_sites_all pavs, hz_party_sites hps
224: WHERE pavs.vendor_id = p_supp_id
225: AND pavs.vendor_site_code = p_site_name
226: AND pavs.org_id = p_org
227: AND pavs.party_site_id = hps.party_site_id;

Line 257: FROM ap_supplier_sites_all

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
261: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,sqlerrm);

Line 1830: from fv_ccr_orgs o, hr_organization_units ou, ap_supplier_sites_all vs

1826:
1827: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
1828: IF p_org_id is NOT NULL THEN
1829: for crec in (select pay_site_id
1830: from fv_ccr_orgs o, hr_organization_units ou, ap_supplier_sites_all vs
1831: where o.pay_site_id is not null
1832: and o.pay_site_id = vs.VENDOR_SITE_ID
1833: and vs.ORG_ID = ou.organization_id
1834: and ou.organization_id = nvl(p_org_id,ou.organization_id)

Line 2314: FROM ap_supplier_sites_all

2310: BEGIN
2311:
2312: SELECT party_site_id,location_id
2313: INTO l_party_site_id,l_location_id
2314: FROM ap_supplier_sites_all
2315: WHERE vendor_site_id = p_vendor_site_id;
2316:
2317: x_party_site_id := l_party_site_id;
2318:

Line 2748: FROM ap_supplier_sites_all

2744: FROM ap_suppliers
2745: WHERE vendor_id=p_vendor_id;
2746:
2747: SELECT party_site_id INTO l_party_site_id
2748: FROM ap_supplier_sites_all
2749: WHERE vendor_site_id = p_pay_site_id;
2750:
2751: if(nvl(l_party_id,0) <> 0 and nvl(p_new_bank_account_id,0) <> 0) THEN
2752: add_owner_party(l_party_id,p_new_bank_account_id);