APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on PER_ALL_ASSIGNMENTS_F

Line 716: per_all_assignments_f asg

712: )
713: and (p_legal_entity_id is null
714: or exists (select null
715: from hr_soft_coding_keyflex hsc,
716: per_all_assignments_f asg
717: where asg.person_id = pil.person_id
718: and asg.assignment_type <> 'C'
719: and asg.primary_flag = 'Y'
720: and asg.business_group_id = pil.business_group_id

Line 1106: from hr_locations_all loc,per_all_assignments_f asg

1102: paf.effective_start_date and paf.effective_end_date;
1103:
1104: Cursor c_state is
1105: select region_2
1106: from hr_locations_all loc,per_all_assignments_f asg
1107: where loc.location_id = asg.location_id
1108: and asg.person_id = p_person_id
1109: and asg.primary_flag = 'Y'
1110: and p_effective_date between