APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIG_PER_TYP_PRTE_F

Line 103: from BEN_ELIG_PER_TYP_PRTE_F

99: );
100: elsif p_crit_type ='PT' then
101: select elig_per_typ_prte_id,object_version_number
102: into l_pk,l_ovn
103: from BEN_ELIG_PER_TYP_PRTE_F
104: where eligy_prfl_id = p_elig_prfl_id
105: and p_effective_date between effective_start_date and effective_end_date;
106: hr_utility.set_location('pk selected is'||l_pk,100);
107:

Line 2455: hr_utility.set_location(' BEN_ELIG_PER_TYP_PRTE_F CREATE_ELIG_PER_TYP_PRTE ',20);

2451: );
2452: end if;
2453: if l_pt_flag = 'Y' then
2454: l_pt_cd := get_per_typ_cd(P_PERSON_TYPE_ID => r_elp.information236);
2455: hr_utility.set_location(' BEN_ELIG_PER_TYP_PRTE_F CREATE_ELIG_PER_TYP_PRTE ',20);
2456: hr_utility.set_location('per type id is'||r_elp.information236,20);
2457: hr_utility.set_location('per type cd is'||l_pt_cd,20);
2458: BEN_ELIG_PER_TYP_PRTE_API.CREATE_ELIG_PER_TYP_PRTE(
2459: P_EFFECTIVE_DATE => l_effective_date

Line 2670: hr_utility.set_location(' BEN_ELIG_PER_TYP_PRTE_F CREATE_ELIG_PER_TYP_PRTE ',20);

2666: p_effective_date => l_effective_date);
2667: end if;
2668: if l_pt_flag = 'Y' and l_old_pt_flag is null and r_elp.information226 is null then
2669: l_pt_cd := get_per_typ_cd(P_PERSON_TYPE_ID => r_elp.information236);
2670: hr_utility.set_location(' BEN_ELIG_PER_TYP_PRTE_F CREATE_ELIG_PER_TYP_PRTE ',20);
2671: BEN_ELIG_PER_TYP_PRTE_API.CREATE_ELIG_PER_TYP_PRTE(
2672: P_EFFECTIVE_DATE => l_effective_date
2673: ,P_BUSINESS_GROUP_ID => p_business_group_id
2674: ,P_ELIGY_PRFL_ID => l_elp_id