APPS.PQH_COMMITMENT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
Line 274: From hr_all_organization_units -- Bug 2471864
270: and language = userenv('LANG');
271: --
272: Cursor csr_org(l_org_id in number) is
273: Select name 274: From hr_all_organization_units -- Bug 2471864 275: Where organization_id = l_org_id;
276: --
277: Cursor csr_job(l_job_id in number) is
278: Select name
Line 416: -- VALIDATE IF THIS IS A VALID ORGANIZATION IN HR_ALL_ORGANIZATION_UNITS
412: If p_budgeted_entity_cd ='ORGANIZATION' then
413:
414: If p_entity_id IS NOT NULL then
415: -- 416: -- VALIDATE IF THIS IS A VALID ORGANIZATION IN HR_ALL_ORGANIZATION_UNITS 417: --
418: Open csr_org(p_entity_id);
419: --
420: Fetch csr_org into p_entity_name;