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 2521: hr_utility.set_location(' BEN_ELIG_JOB_PRTE_F CREATE_ELIGY_JOB_PRTE ',20);

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

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

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