APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on PER_ALL_ASSIGNMENTS_F

Line 3190: from per_all_assignments_f asg

3186: l_rslt c_rslt%rowtype;
3187:
3188: cursor c_asg is
3189: select asg.assignment_id,asg.organization_id
3190: from per_all_assignments_f asg
3191: where asg.person_id = l_rslt.person_id
3192: and asg.assignment_type <> 'C'
3193: and asg.primary_flag = 'Y'
3194: and p_effective_date between

Line 3201: from hr_locations_all loc,per_all_assignments_f asg

3197: l_asg c_asg%rowtype;
3198:
3199: Cursor c_state is
3200: select region_2
3201: from hr_locations_all loc,per_all_assignments_f asg
3202: where loc.location_id = asg.location_id
3203: and asg.person_id = l_rslt.person_id
3204: and asg.assignment_type <> 'C'
3205: and p_effective_date between

Line 7646: FROM per_all_assignments_f asg

7642: pen_info_rec c_pen_info%ROWTYPE;
7643: --
7644: cursor c_asg(v_person_id in number) is
7645: SELECT asg.assignment_id, asg.organization_id
7646: FROM per_all_assignments_f asg
7647: WHERE asg.person_id = v_person_id
7648: AND asg.assignment_type <> 'C'
7649: AND asg.primary_flag = 'Y'
7650: AND p_effective_date BETWEEN asg.effective_start_date

Line 8682: from per_all_assignments_f asg

8678: l_opt c_opt%rowtype;
8679:
8680: cursor c_asg is
8681: select asg.assignment_id,asg.organization_id
8682: from per_all_assignments_f asg
8683: where asg.person_id = l_rslt.person_id
8684: and asg.assignment_type <> 'C'
8685: and asg.primary_flag = 'Y'
8686: and p_effective_date between