DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIG_JOB_PRTE_F

Line 199: from BEN_ELIG_JOB_PRTE_F

195: );
196: elsif p_crit_type ='JOB' then
197: select elig_job_prte_id,object_version_number
198: into l_pk,l_ovn
199: from BEN_ELIG_JOB_PRTE_F
200: where eligy_prfl_id = p_elig_prfl_id
201: and p_effective_date between effective_start_date and effective_end_date;
202: hr_utility.set_location('pk selected is'||l_pk,100);
203:

Line 2520: hr_utility.set_location(' BEN_ELIG_JOB_PRTE_F CREATE_ELIGY_JOB_PRTE ',20);

2516: ,P_OBJECT_VERSION_NUMBER => l_ovn
2517: );
2518: end if;
2519: if l_job_flag = 'Y' then
2520: hr_utility.set_location(' BEN_ELIG_JOB_PRTE_F CREATE_ELIGY_JOB_PRTE ',20);
2521: hr_utility.set_location('org id is'||r_elp.information233,20);
2522: BEN_ELIGY_JOB_PRTE_API.CREATE_ELIGY_JOB_PRTE(
2523: P_EFFECTIVE_DATE => l_effective_date
2524: ,P_BUSINESS_GROUP_ID => p_business_group_id

Line 2746: hr_utility.set_location(' BEN_ELIG_JOB_PRTE_F CREATE_ELIGY_JOB_PRTE ',20);

2742: p_crit_type => 'ORG',
2743: p_effective_date => l_effective_date);
2744: end if;
2745: if l_job_flag = 'Y' and l_old_job_flag is null and r_elp.information223 is null then
2746: hr_utility.set_location(' BEN_ELIG_JOB_PRTE_F CREATE_ELIGY_JOB_PRTE ',20);
2747: BEN_ELIGY_JOB_PRTE_API.CREATE_ELIGY_JOB_PRTE(
2748: P_EFFECTIVE_DATE => l_effective_date
2749: ,P_BUSINESS_GROUP_ID => p_business_group_id
2750: ,P_ELIGY_PRFL_ID => l_elp_id