DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIG_SVC_AREA_PRTE_F

Line 151: from BEN_ELIG_SVC_AREA_PRTE_F

147: );
148: elsif p_crit_type ='SA' then
149: select elig_svc_area_prte_id,object_version_number
150: into l_pk,l_ovn
151: from BEN_ELIG_SVC_AREA_PRTE_F
152: where eligy_prfl_id = p_elig_prfl_id
153: and p_effective_date between effective_start_date and effective_end_date;
154: hr_utility.set_location('pk selected is'||l_pk,100);
155:

Line 2472: hr_utility.set_location(' BEN_ELIG_SVC_AREA_PRTE_F CREATE_ELIG_SVC_AREA_PRTE ',20);

2468: ,P_OBJECT_VERSION_NUMBER => l_ovn
2469: );
2470: end if;
2471: if l_sa_flag = 'Y' then
2472: hr_utility.set_location(' BEN_ELIG_SVC_AREA_PRTE_F CREATE_ELIG_SVC_AREA_PRTE ',20);
2473: hr_utility.set_location('serv area id is'||r_elp.information237,20);
2474: BEN_ELIG_SVC_AREA_PRTE_API.CREATE_ELIG_SVC_AREA_PRTE(
2475: P_EFFECTIVE_DATE => l_effective_date
2476: ,P_BUSINESS_GROUP_ID => p_business_group_id

Line 2689: hr_utility.set_location(' BEN_ELIG_SVC_AREA_PRTE_F CREATE_ELIG_SVC_AREA_PRTE ',20);

2685: p_crit_type => 'PT',
2686: p_effective_date => l_effective_date);
2687: end if;
2688: if l_sa_flag = 'Y' and l_old_sa_flag is null and r_elp.information227 is null then
2689: hr_utility.set_location(' BEN_ELIG_SVC_AREA_PRTE_F CREATE_ELIG_SVC_AREA_PRTE ',20);
2690: BEN_ELIG_SVC_AREA_PRTE_API.CREATE_ELIG_SVC_AREA_PRTE(
2691: P_EFFECTIVE_DATE => l_effective_date
2692: ,P_BUSINESS_GROUP_ID => p_business_group_id
2693: ,P_ELIGY_PRFL_ID => l_elp_id