DBA Data[Home] [Help]

APPS.HR_WPM_IMPORT_LIB_OBJ_API dependencies on HR_ORGANIZATION_UNITS

Line 120: cursor bg_cur(cur_p_org_id number) is select BUSINESS_GROUP_ID into l_bg_id from hr_organization_units where ORGANIZATION_ID=cur_p_org_id;

116: p_return_status varchar2(400);
117: is_profile_exists varchar2(1);
118: l_elig_prfl_bg_id number(30);
119:
120: cursor bg_cur(cur_p_org_id number) is select BUSINESS_GROUP_ID into l_bg_id from hr_organization_units where ORGANIZATION_ID=cur_p_org_id;
121:
122: cursor csr_name(cur_p_eligy_prfl_id number,cur_p_effective_date date) is
123: select 'Y',BUSINESS_GROUP_ID
124: from ben_eligy_prfl_f