DBA Data[Home] [Help]

APPS.FV_CCR_UTIL_PVT dependencies on HR_ORGANIZATION_UNITS

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 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