APPS.BEN_PROVIDER_POOLS dependencies on HR_LOCATIONS_ALL

Line 342: hr_locations_all loc

338: select asg.assignment_id,
339: asg.organization_id,
340: loc.region_2
341: from per_all_assignments_f asg,
342: hr_locations_all loc
343: where
344: asg.person_id = p_person_id and
345: asg.assignment_type <> 'C'and
346: asg.primary_flag='Y' and

Line 3535: hr_locations_all loc,

3531: ben_enrt_rt ecr,
3532: ben_prtt_rt_val prv,
3533: ben_prtt_enrt_rslt_f rslt,
3534: per_all_assignments_f asg,
3535: hr_locations_all loc,
3536: ben_oipl_f oipl
3537: where
3538: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
3539: prr.business_group_id=p_business_group_id and

Line 3612: hr_locations_all loc,

3608: ben_enrt_rt ecr,
3609: ben_prtt_rt_val prv,
3610: ben_prtt_enrt_rslt_f rslt,
3611: per_all_assignments_f asg,
3612: hr_locations_all loc,
3613: ben_oipl_f oipl
3614: where
3615: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
3616: prr.business_group_id=p_business_group_id and

Line 5671: hr_locations_all loc,

5667: ben_bnft_pool_rlovr_rqmt_f prr,
5668: ben_prtt_rt_val prv,
5669: ben_prtt_enrt_rslt_f rslt,
5670: per_all_assignments_f asg,
5671: hr_locations_all loc,
5672: ben_oipl_f oipl
5673: where
5674: prr.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id and
5675: prr.business_group_id=p_business_group_id and