APPS.HR_ORU_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 544: from hr_organization_information i

540: for Crec in C1 loop
541:
542: select count(*)
543: into l_bg
544: from hr_organization_information i
545: where i.organization_id = crec.organization_id
546: and i.org_information1='HR_BG'
547: and i.org_information_context='CLASS'
548: and i.org_information2 ='Y';

Line 744: FROM hr_organization_information

740: IF p_organization_id IS NOT NULL THEN
741: --
742: SELECT COUNT(*)
743: INTO l_count
744: FROM hr_organization_information
745: WHERE organization_id = p_organization_id
746: AND org_information_context = 'CLASS'
747: AND org_information1 = 'HR_ORG'
748: AND org_information2 = 'Y';

Line 1050: FROM hr_organization_information

1046: INTO l_exists
1047: FROM sys.dual
1048: WHERE EXISTS
1049: (SELECT null
1050: FROM hr_organization_information
1051: WHERE organization_id = p_organization_id
1052: AND org_information_context = 'CLASS'
1053: AND org_information2 = 'Y'
1054: );