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 2387: hr_utility.set_location(' BEN_ELIGY_PRFL_RL_F CREATE_ELIGY_PROFILE_RULE ',20);

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

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

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