APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIGY_PRFL_RL_F

Line 71: from BEN_ELIGY_PRFL_RL_F

67: hr_utility.set_location('crit passed is'||p_crit_type,100);
68: if p_crit_type ='RL' then
69: select eligy_prfl_rl_id,object_version_number
70: into l_pk,l_ovn
71: from BEN_ELIGY_PRFL_RL_F
72: where eligy_prfl_id = p_elig_prfl_id
73: and p_effective_date between effective_start_date and effective_end_date;
74: hr_utility.set_location('pk selected is'||l_pk,100);
75:

Line 2388: hr_utility.set_location(' BEN_ELIGY_PRFL_RL_F CREATE_ELIGY_PROFILE_RULE ',20);

2384: p_elp_id => l_elp_id,
2385: p_copy_entity_txn_id => p_copy_entity_txn_id);
2386: hr_utility.set_location('effdt is '||to_char(l_effective_date,'DD/MM/RRRR'),20);
2387: if l_rl_flag = 'Y' then
2388: hr_utility.set_location(' BEN_ELIGY_PRFL_RL_F CREATE_ELIGY_PROFILE_RULE ',20);
2389: hr_utility.set_location('rule id is'||r_elp.information235,20);
2390: BEN_ELIGY_PROFILE_RULE_API.CREATE_ELIGY_PROFILE_RULE(
2391: P_EFFECTIVE_DATE => l_effective_date
2392: ,P_BUSINESS_GROUP_ID => p_business_group_id

Line 2592: hr_utility.set_location(' BEN_ELIGY_PRFL_RL_F CREATE_ELIGY_PROFILE_RULE ',20);

2588: raise;
2589: end;
2590: end if;
2591: if l_rl_flag = 'Y' and l_old_rl_flag is null and r_elp.information225 is null then
2592: hr_utility.set_location(' BEN_ELIGY_PRFL_RL_F CREATE_ELIGY_PROFILE_RULE ',20);
2593: BEN_ELIGY_PROFILE_RULE_API.CREATE_ELIGY_PROFILE_RULE(
2594: P_EFFECTIVE_DATE => l_effective_date
2595: ,P_BUSINESS_GROUP_ID => p_business_group_id
2596: ,P_DRVBL_FCTR_APLS_FLAG => 'N'