DBA Data[Home] [Help]

APPS.FV_CCR_UTIL_PVT dependencies on HR_ORGANIZATION_UNITS

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

2047:
2048: --v_org_id := fv_ccr_util_pvt.get_profile_option('ORG_ID');
2049: IF p_org_id is NOT NULL THEN
2050: for crec in (select pay_site_id
2051: from fv_ccr_orgs o, hr_organization_units ou, ap_supplier_sites_all vs
2052: where o.pay_site_id is not null
2053: and o.pay_site_id = vs.VENDOR_SITE_ID
2054: and vs.ORG_ID = ou.organization_id
2055: and ou.organization_id = nvl(p_org_id,ou.organization_id)

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