APPS.BEN_DETERMINE_COVERAGE dependencies on PER_ALL_ASSIGNMENTS_F

Line 519: from per_all_assignments_f asg

515: l_other_cvg number;
516: --
517: cursor c_asg(cv_effective_date date) is -- FONM
518: select asg.assignment_id,asg.organization_id
519: from per_all_assignments_f asg
520: where asg.person_id = p_person_id
521: and asg.primary_flag = 'Y'
522: and asg.assignment_type <> 'C'
523: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 578: per_all_assignments_f asg

574: --
575: cursor c_state(cv_effective_date date) is -- FONM
576: select region_2
577: from hr_locations_all loc,
578: per_all_assignments_f asg
579: where loc.location_id = asg.location_id
580: and asg.person_id = p_person_id
581: and asg.primary_flag = 'Y'
582: and asg.assignment_type <> 'C'

Line 1232: from per_all_assignments_f

1228: --
1229: /* Bug 5331889 */
1230: cursor fetch_person_id is
1231: select person_id
1232: from per_all_assignments_f
1233: where assignment_id = p_assignment_id;
1234: l_person_id number;
1235:
1236: BEGIN

Line 1714: from per_all_assignments_f asg

1710: l_cvg ben_cvg_cache.g_epeplncvg_cache;
1711: --
1712: cursor c_asg(cv_effective_date date) is -- FONM
1713: select asg.assignment_id,asg.organization_id
1714: from per_all_assignments_f asg
1715: where asg.person_id = l_epe.person_id
1716: and asg.primary_flag = 'Y'
1717: and asg.assignment_type <> 'C'
1718: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 1728: per_all_assignments_f asg

1724: --
1725: cursor c_state (cv_effective_date date) is -- FONM
1726: select region_2
1727: from hr_locations_all loc,
1728: per_all_assignments_f asg
1729: where loc.location_id = asg.location_id
1730: and asg.person_id = l_epe.person_id
1731: and asg.primary_flag = 'Y'
1732: and asg.assignment_type <> 'C'