APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1538: FROM hr_locations_all loc, per_all_assignments_f asg

1534: --
1535: --
1536: CURSOR c_state IS
1537: SELECT loc.region_2
1538: FROM hr_locations_all loc, per_all_assignments_f asg
1539: WHERE loc.location_id = asg.location_id
1540: AND asg.person_id = p_person_id
1541: and asg.assignment_type <> 'C'
1542: AND asg.primary_flag = 'Y'

Line 1553: FROM per_all_assignments_f asg

1549: --
1550: CURSOR c_asg IS
1551: SELECT asg.assignment_id,
1552: asg.organization_id
1553: FROM per_all_assignments_f asg
1554: WHERE person_id = p_person_id
1555: and asg.assignment_type <> 'C'
1556: AND asg.primary_flag = decode(p_run_mode, 'I',asg.primary_flag, 'Y') -- iRec
1557: AND l_lf_evt_ocrd_dt BETWEEN asg.effective_start_date

Line 2213: from per_all_assignments_f

2209: cursor c_get_assignment is
2210: select assignment_id,
2211: position_id,
2212: supervisor_id
2213: from per_all_assignments_f
2214: where person_id = p_person_id
2215: and primary_flag = 'Y'
2216: and assignment_type in ( 'E','C' ) -- Bug 2827121
2217: and p_effective_date

Line 2232: from per_all_assignments_f ass,

2228: --
2229: cursor c_manager_id (p_position_id number)
2230: is
2231: select person_id
2232: from per_all_assignments_f ass,
2233: per_assignment_status_types ast
2234: where ass.position_id = p_position_id
2235: and ass.primary_flag = 'Y'
2236: and ass.assignment_type in ( 'E' , 'C' ) -- Bug 2827121

Line 2780: FROM hr_locations_all loc, per_all_assignments_f asg

2776: AND bpt.business_group_id = p_business_group_id;
2777: --
2778: CURSOR c_state IS
2779: SELECT loc.region_2
2780: FROM hr_locations_all loc, per_all_assignments_f asg
2781: WHERE loc.location_id = asg.location_id
2782: AND asg.person_id = p_person_id
2783: and asg.assignment_type <> 'C'
2784: AND asg.primary_flag = 'Y'

Line 2794: FROM per_all_assignments_f asg

2790: --
2791: CURSOR c_asg IS
2792: SELECT asg.assignment_id,
2793: asg.organization_id
2794: FROM per_all_assignments_f asg
2795: WHERE asg.person_id = p_person_id
2796: and asg.assignment_type <> 'C'
2797: AND asg.primary_flag = decode (p_run_mode, 'I', asg.primary_flag, 'Y')-- iREC
2798: AND l_lf_evt_ocrd_dt BETWEEN asg.effective_start_date

Line 8172: FROM hr_locations_all loc, per_all_assignments_f asg

8168:
8169: --
8170: CURSOR c_state IS
8171: SELECT loc.region_2
8172: FROM hr_locations_all loc, per_all_assignments_f asg
8173: WHERE loc.location_id = asg.location_id
8174: AND asg.person_id = p_person_id
8175: and asg.assignment_type <> 'C'
8176: AND asg.primary_flag = 'Y'

Line 8185: FROM per_all_assignments_f asg

8181: l_state c_state%ROWTYPE;
8182: CURSOR c_asg IS
8183: SELECT asg.assignment_id,
8184: asg.organization_id
8185: FROM per_all_assignments_f asg
8186: WHERE asg.person_id = p_person_id
8187: and asg.assignment_type <> 'C'
8188: AND asg.primary_flag = decode(p_run_mode, 'I',asg.primary_flag, 'Y') -- iRec
8189: AND l_lf_evt_ocrd_dt BETWEEN asg.effective_start_date

Line 9769: FROM per_all_assignments_f asg

9765: AND bpf.effective_end_date;
9766: CURSOR c_asg IS
9767: SELECT asg.assignment_id,
9768: asg.organization_id
9769: FROM per_all_assignments_f asg
9770: WHERE asg.person_id = p_person_id
9771: and asg.assignment_type <> 'C'
9772: AND asg.primary_flag = decode(p_run_mode, 'I',asg.primary_flag,'Y') -- iRec
9773: AND l_lf_evt_ocrd_dt BETWEEN asg.effective_start_date