DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIG_FL_TM_PT_TM_PRTE_F

Line 119: from BEN_ELIG_FL_TM_PT_TM_PRTE_F

115: );
116: elsif p_crit_type ='FP' then
117: select elig_fl_tm_pt_tm_prte_id,object_version_number
118: into l_pk,l_ovn
119: from BEN_ELIG_FL_TM_PT_TM_PRTE_F
120: where eligy_prfl_id = p_elig_prfl_id
121: and p_effective_date between effective_start_date and effective_end_date;
122: hr_utility.set_location('pk selected is'||l_pk,100);
123:

Line 2420: hr_utility.set_location(' BEN_ELIG_FL_TM_PT_TM_PRTE_F CREATE_ELIG_FL_TM_PT_TM_PRTE ',20);

2416: ,P_OBJECT_VERSION_NUMBER => l_ovn
2417: );
2418: end if;
2419: if l_fp_flag = 'Y' then
2420: hr_utility.set_location(' BEN_ELIG_FL_TM_PT_TM_PRTE_F CREATE_ELIG_FL_TM_PT_TM_PRTE ',20);
2421: hr_utility.set_location('fulltime cd is'||r_elp.information102,20);
2422: BEN_ELIG_FL_TM_PT_TM_PRTE_API.CREATE_ELIG_FL_TM_PT_TM_PRTE(
2423: P_EFFECTIVE_DATE => l_effective_date
2424: ,P_BUSINESS_GROUP_ID => p_business_group_id

Line 2630: hr_utility.set_location(' BEN_ELIG_FL_TM_PT_TM_PRTE_F CREATE_ELIG_FL_TM_PT_TM_PRTE ',20);

2626: p_crit_type => 'BU',
2627: p_effective_date => l_effective_date);
2628: end if;
2629: if l_fp_flag = 'Y' and l_old_fp_flag is null and r_elp.information229 is null then
2630: hr_utility.set_location(' BEN_ELIG_FL_TM_PT_TM_PRTE_F CREATE_ELIG_FL_TM_PT_TM_PRTE ',20);
2631: BEN_ELIG_FL_TM_PT_TM_PRTE_API.CREATE_ELIG_FL_TM_PT_TM_PRTE(
2632: P_EFFECTIVE_DATE => l_effective_date
2633: ,P_BUSINESS_GROUP_ID => p_business_group_id
2634: ,P_ELIGY_PRFL_ID => l_elp_id