eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2473: hr_utility.set_location(' BEN_ELIG_SVC_AREA_PRTE_F CREATE_ELIG_SVC_AREA_PRTE ',20);

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

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

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