DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIG_WK_LOC_PRTE_F

Line 167: from BEN_ELIG_WK_LOC_PRTE_F

163: );
164: elsif p_crit_type ='LOC' then
165: select elig_wk_loc_prte_id,object_version_number
166: into l_pk,l_ovn
167: from BEN_ELIG_WK_LOC_PRTE_F
168: where eligy_prfl_id = p_elig_prfl_id
169: and p_effective_date between effective_start_date and effective_end_date;
170: hr_utility.set_location('pk selected is'||l_pk,100);
171:

Line 2489: hr_utility.set_location(' BEN_ELIG_WK_LOC_PRTE_F CREATE_ELIG_WK_LOC_PRTE ',20);

2485: ,P_OBJECT_VERSION_NUMBER => l_ovn
2486: );
2487: end if;
2488: if l_loc_flag = 'Y' then
2489: hr_utility.set_location(' BEN_ELIG_WK_LOC_PRTE_F CREATE_ELIG_WK_LOC_PRTE ',20);
2490: hr_utility.set_location('location id is'||r_elp.information232,20);
2491: BEN_ELIG_WK_LOC_PRTE_API.CREATE_ELIG_WK_LOC_PRTE(
2492: P_EFFECTIVE_DATE => l_effective_date
2493: ,P_BUSINESS_GROUP_ID => p_business_group_id

Line 2709: hr_utility.set_location(' BEN_ELIG_WK_LOC_PRTE_F CREATE_ELIG_WK_LOC_PRTE ',20);

2705: p_crit_type => 'SA',
2706: p_effective_date => l_effective_date);
2707: end if;
2708: if l_loc_flag = 'Y' and l_old_loc_flag is null and r_elp.information222 is null then
2709: hr_utility.set_location(' BEN_ELIG_WK_LOC_PRTE_F CREATE_ELIG_WK_LOC_PRTE ',20);
2710: BEN_ELIG_WK_LOC_PRTE_API.CREATE_ELIG_WK_LOC_PRTE(
2711: P_EFFECTIVE_DATE => l_effective_date
2712: ,P_BUSINESS_GROUP_ID => p_business_group_id
2713: ,P_ELIGY_PRFL_ID => l_elp_id