DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIG_PERF_RTNG_PRTE_F

Line 87: from BEN_ELIG_PERF_RTNG_PRTE_F

83: );
84: elsif p_crit_type ='PR' then
85: select elig_perf_rtng_prte_id,object_version_number
86: into l_pk,l_ovn
87: from BEN_ELIG_PERF_RTNG_PRTE_F
88: where eligy_prfl_id = p_elig_prfl_id
89: and p_effective_date between effective_start_date and effective_end_date;
90: hr_utility.set_location('pk selected is'||l_pk,100);
91:

Line 2436: hr_utility.set_location(' BEN_ELIG_PERF_RTNG_PRTE_F CREATE_ELIG_PERF_RTNG_PRTE ',20);

2432: ,P_OBJECT_VERSION_NUMBER => l_ovn
2433: );
2434: end if;
2435: if l_pr_flag = 'Y' then
2436: hr_utility.set_location(' BEN_ELIG_PERF_RTNG_PRTE_F CREATE_ELIG_PERF_RTNG_PRTE ',20);
2437: hr_utility.set_location('event type is'||r_elp.information103,20);
2438: hr_utility.set_location('perf_rtng_cd is'||r_elp.information104,20);
2439: BEN_ELIG_PERF_RTNG_PRTE_API.CREATE_ELIG_PERF_RTNG_PRTE(
2440: P_EFFECTIVE_DATE => l_effective_date

Line 2649: hr_utility.set_location(' BEN_ELIG_PERF_RTNG_PRTE_F CREATE_ELIG_PERF_RTNG_PRTE ',20);

2645: p_crit_type => 'FP',
2646: p_effective_date => l_effective_date);
2647: end if;
2648: if l_pr_flag = 'Y' and l_old_pr_flag is null and r_elp.information230 is null then
2649: hr_utility.set_location(' BEN_ELIG_PERF_RTNG_PRTE_F CREATE_ELIG_PERF_RTNG_PRTE ',20);
2650: BEN_ELIG_PERF_RTNG_PRTE_API.CREATE_ELIG_PERF_RTNG_PRTE(
2651: P_EFFECTIVE_DATE => l_effective_date
2652: ,P_BUSINESS_GROUP_ID => p_business_group_id
2653: ,P_ELIGY_PRFL_ID => l_elp_id