APPS.HR_ORG_UTILITY dependencies on HR_ORGANIZATION_INFORMATION

Line 19: from hr_organization_information org2,

15: l_cnt number;
16:
17: Cursor c1 is
18: select 1
19: from hr_organization_information org2,
20: hr_org_info_types_by_class oitbc
21: where org2.organization_id = p_organization_id
22: and org2.org_information_context||'' = 'CLASS'
23: and org2.org_information2 = 'Y'

Line 31: from hr_organization_information

27:
28: BEGIN
29: select count(distinct org_information_context)
30: into l_cnt
31: from hr_organization_information
32: where organization_id = p_organization_id
33: and org_information_context in ('Organization Name Alias', 'CLASS');
34:
35: --Return if both classifications are not present.