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 2488: hr_utility.set_location(' BEN_ELIG_WK_LOC_PRTE_F CREATE_ELIG_WK_LOC_PRTE ',20);

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

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

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