APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1511: FROM hr_locations_all loc, per_all_assignments_f asg

1507: --
1508: --
1509: CURSOR c_state IS
1510: SELECT loc.region_2
1511: FROM hr_locations_all loc, per_all_assignments_f asg
1512: WHERE loc.location_id = asg.location_id
1513: AND asg.person_id = p_person_id
1514: and asg.assignment_type <> 'C'
1515: AND asg.primary_flag = 'Y'

Line 1526: FROM per_all_assignments_f asg

1522: --
1523: CURSOR c_asg IS
1524: SELECT asg.assignment_id,
1525: asg.organization_id
1526: FROM per_all_assignments_f asg
1527: WHERE person_id = p_person_id
1528: and asg.assignment_type <> 'C'
1529: AND asg.primary_flag = decode(p_run_mode, 'I',asg.primary_flag, 'Y') -- iRec
1530: AND l_lf_evt_ocrd_dt BETWEEN asg.effective_start_date

Line 2186: from per_all_assignments_f

2182: cursor c_get_assignment is
2183: select assignment_id,
2184: position_id,
2185: supervisor_id
2186: from per_all_assignments_f
2187: where person_id = p_person_id
2188: and primary_flag = 'Y'
2189: and assignment_type in ( 'E','C' ) -- Bug 2827121
2190: and p_effective_date

Line 2205: from per_all_assignments_f ass,

2201: --
2202: cursor c_manager_id (p_position_id number)
2203: is
2204: select person_id
2205: from per_all_assignments_f ass,
2206: per_assignment_status_types ast
2207: where ass.position_id = p_position_id
2208: and ass.primary_flag = 'Y'
2209: and ass.assignment_type in ( 'E' , 'C' ) -- Bug 2827121

Line 2749: FROM hr_locations_all loc, per_all_assignments_f asg

2745: AND bpt.business_group_id = p_business_group_id;
2746: --
2747: CURSOR c_state IS
2748: SELECT loc.region_2
2749: FROM hr_locations_all loc, per_all_assignments_f asg
2750: WHERE loc.location_id = asg.location_id
2751: AND asg.person_id = p_person_id
2752: and asg.assignment_type <> 'C'
2753: AND asg.primary_flag = 'Y'

Line 2763: FROM per_all_assignments_f asg

2759: --
2760: CURSOR c_asg IS
2761: SELECT asg.assignment_id,
2762: asg.organization_id
2763: FROM per_all_assignments_f asg
2764: WHERE asg.person_id = p_person_id
2765: and asg.assignment_type <> 'C'
2766: AND asg.primary_flag = decode (p_run_mode, 'I', asg.primary_flag, 'Y')-- iREC
2767: AND l_lf_evt_ocrd_dt BETWEEN asg.effective_start_date

Line 8035: FROM hr_locations_all loc, per_all_assignments_f asg

8031:
8032: --
8033: CURSOR c_state IS
8034: SELECT loc.region_2
8035: FROM hr_locations_all loc, per_all_assignments_f asg
8036: WHERE loc.location_id = asg.location_id
8037: AND asg.person_id = p_person_id
8038: and asg.assignment_type <> 'C'
8039: AND asg.primary_flag = 'Y'

Line 8048: FROM per_all_assignments_f asg

8044: l_state c_state%ROWTYPE;
8045: CURSOR c_asg IS
8046: SELECT asg.assignment_id,
8047: asg.organization_id
8048: FROM per_all_assignments_f asg
8049: WHERE asg.person_id = p_person_id
8050: and asg.assignment_type <> 'C'
8051: AND asg.primary_flag = decode(p_run_mode, 'I',asg.primary_flag, 'Y') -- iRec
8052: AND l_lf_evt_ocrd_dt BETWEEN asg.effective_start_date

Line 9627: FROM per_all_assignments_f asg

9623: AND bpf.effective_end_date;
9624: CURSOR c_asg IS
9625: SELECT asg.assignment_id,
9626: asg.organization_id
9627: FROM per_all_assignments_f asg
9628: WHERE asg.person_id = p_person_id
9629: and asg.assignment_type <> 'C'
9630: AND asg.primary_flag = decode(p_run_mode, 'I',asg.primary_flag,'Y') -- iRec
9631: AND l_lf_evt_ocrd_dt BETWEEN asg.effective_start_date