DBA Data[Home] [Help]

APPS.GHR_SS_ASG_EIT dependencies on HR_ORGANIZATION_INFORMATION

Line 43: from hr_organization_information oi

39:
40:
41: CURSOR c_fed_setup_avl IS
42: select count(1)
43: from hr_organization_information oi
44: where oi.org_information_context = 'GHR_US_ORG_INFORMATION'
45: and oi.org_information1 is not null
46: and oi.org_information2 is not null
47: and oi.org_information3 is not null

Line 139: from hr_organization_information oi

135: l_row_id rowid;
136:
137: CURSOR c_fed_setup_avl IS
138: select count(1)
139: from hr_organization_information oi
140: where oi.org_information_context = 'GHR_US_ORG_INFORMATION'
141: and oi.org_information1 is not null
142: and oi.org_information2 is not null
143: and oi.org_information3 is not null