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
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