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 2435: hr_utility.set_location(' BEN_ELIG_PERF_RTNG_PRTE_F CREATE_ELIG_PERF_RTNG_PRTE ',20);

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

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

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