DBA Data[Home] [Help]

APPS.HR_WPM_IMPORT_LIB_OBJ_API dependencies on BEN_ELIGY_PRFL_F

Line 124: from ben_eligy_prfl_f

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
125: where eligy_prfl_id = cur_p_eligy_prfl_id
126: and cur_p_effective_date <= nvl(effective_end_date,to_date('31-12-4712','DD-MM-YYYY'))
127: and cur_p_effective_date >= effective_start_date
128: and stat_cd='A' ;