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.BEN_PROVIDER_POOLS dependencies on HR_LOCATIONS_ALL

Line 324: hr_locations_all loc

320: select asg.assignment_id,
321: asg.organization_id,
322: loc.region_2
323: from per_all_assignments_f asg,
324: hr_locations_all loc
325: where
326: asg.person_id = p_person_id and
327: asg.assignment_type <> 'C'and
328: asg.primary_flag='Y' and

Line 3356: hr_locations_all loc,

3352: ben_enrt_rt ecr,
3353: ben_prtt_rt_val prv,
3354: ben_prtt_enrt_rslt_f rslt,
3355: per_all_assignments_f asg,
3356: hr_locations_all loc,
3357: ben_oipl_f oipl
3358: where
3359: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
3360: prr.business_group_id=p_business_group_id and

Line 3433: hr_locations_all loc,

3429: ben_enrt_rt ecr,
3430: ben_prtt_rt_val prv,
3431: ben_prtt_enrt_rslt_f rslt,
3432: per_all_assignments_f asg,
3433: hr_locations_all loc,
3434: ben_oipl_f oipl
3435: where
3436: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
3437: prr.business_group_id=p_business_group_id and

Line 5494: hr_locations_all loc,

5490: ben_bnft_pool_rlovr_rqmt_f prr,
5491: ben_prtt_rt_val prv,
5492: ben_prtt_enrt_rslt_f rslt,
5493: per_all_assignments_f asg,
5494: hr_locations_all loc,
5495: ben_oipl_f oipl
5496: where
5497: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
5498: prr.business_group_id=p_business_group_id and