APPS.BEN_DETERMINE_COVERAGE dependencies on PER_ALL_ASSIGNMENTS_F

Line 543: from per_all_assignments_f asg

539: l_other_cvg number;
540: --
541: cursor c_asg(cv_effective_date date) is -- FONM
542: select asg.assignment_id,asg.organization_id
543: from per_all_assignments_f asg
544: where asg.person_id = p_person_id
545: and asg.primary_flag = 'Y'
546: and asg.assignment_type <> 'C'
547: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 602: per_all_assignments_f asg

598: --
599: cursor c_state(cv_effective_date date) is -- FONM
600: select region_2
601: from hr_locations_all loc,
602: per_all_assignments_f asg
603: where loc.location_id = asg.location_id
604: and asg.person_id = p_person_id
605: and asg.primary_flag = 'Y'
606: and asg.assignment_type <> 'C'

Line 1271: from per_all_assignments_f

1267: --
1268: /* Bug 5331889 */
1269: cursor fetch_person_id is
1270: select person_id
1271: from per_all_assignments_f
1272: where assignment_id = p_assignment_id;
1273: l_person_id number;
1274:
1275: BEGIN

Line 1753: from per_all_assignments_f asg

1749: l_cvg ben_cvg_cache.g_epeplncvg_cache;
1750: --
1751: cursor c_asg(cv_effective_date date) is -- FONM
1752: select asg.assignment_id,asg.organization_id
1753: from per_all_assignments_f asg
1754: where asg.person_id = l_epe.person_id
1755: and asg.primary_flag = 'Y'
1756: and asg.assignment_type <> 'C'
1757: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 1767: per_all_assignments_f asg

1763: --
1764: cursor c_state (cv_effective_date date) is -- FONM
1765: select region_2
1766: from hr_locations_all loc,
1767: per_all_assignments_f asg
1768: where loc.location_id = asg.location_id
1769: and asg.person_id = l_epe.person_id
1770: and asg.primary_flag = 'Y'
1771: and asg.assignment_type <> 'C'