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_HR_TO_STAGE dependencies on BEN_OIPL_F

Line 2243: from ben_oipl_f

2239: if l_pl_id is not null and l_opt_id is not null then
2240: begin
2241: select oipl_id
2242: into l_oipl_id
2243: from ben_oipl_f
2244: where pl_id = l_pl_id
2245: and opt_id = l_opt_id
2246: and p_effective_date between effective_start_date and effective_end_date;
2247: hr_utility.set_location('oipl is '||l_oipl_id,30);

Line 2274: from ben_oipl_f

2270: begin
2271: begin
2272: select pl_id,opt_id
2273: into l_pl_id,l_opt_id
2274: from ben_oipl_f
2275: where oipl_id = p_oipl_id
2276: and p_effective_date between effective_start_date and effective_end_date;
2277: exception
2278: when no_data_found then

Line 2921: from ben_oipl_f

2917: hr_utility.set_location('oipl_id is '||p_oipl_id,10);
2918: begin
2919: select opt_id,pl_id
2920: into l_option_id,l_plan_id
2921: from ben_oipl_f
2922: where oipl_id = p_oipl_id
2923: and p_effective_date between effective_start_date and effective_end_date;
2924: hr_utility.set_location('option is '||l_option_id,10);
2925: hr_utility.set_location('plan is '||l_plan_id,15);