APPS.PER_SSM_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 914: from hr_all_organization_units o

910: l_bg number;
911: --
912: cursor csr_chk_company_org is
913: select o.business_group_id, o.date_from, nvl(o.date_to,hr_api.g_eot)
914: from hr_all_organization_units o
915: where o.organization_id = p_company_organization_id;
916: --
917: cursor csr_get_bg is
918: select business_group_id

Line 947: -- raise error as FK does not relate to PK in hr_all_organization_units

943: If csr_chk_company_org%notfound then
944: hr_utility.set_location(l_proc,25);
945: close csr_chk_company_org;
946: --
947: -- raise error as FK does not relate to PK in hr_all_organization_units
948: -- table.
949: --
950: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK5');
951: --

Line 1032: -- raise error as FK does not relate to PK in hr_all_organization_units

1028: fetch csr_chk_company_age_exists into l_exists;
1029: If csr_chk_company_age_exists%notfound then
1030: close csr_chk_company_age_exists;
1031: --
1032: -- raise error as FK does not relate to PK in hr_all_organization_units
1033: -- table.
1034: --
1035: -- per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK');
1036: fnd_message.set_name('PER','PER_52495_SSM_AGE_DATE_INVL');