APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on PER_ALL_ASSIGNMENTS_F

Line 721: per_all_assignments_f asg

717: )
718: and (p_legal_entity_id is null
719: or exists (select null
720: from hr_soft_coding_keyflex hsc,
721: per_all_assignments_f asg
722: where asg.person_id = pil.person_id
723: and asg.assignment_type <> 'C'
724: and asg.primary_flag = 'Y'
725: and asg.business_group_id = pil.business_group_id

Line 1111: from hr_locations_all loc,per_all_assignments_f asg

1107: paf.effective_start_date and paf.effective_end_date;
1108:
1109: Cursor c_state is
1110: select region_2
1111: from hr_locations_all loc,per_all_assignments_f asg
1112: where loc.location_id = asg.location_id
1113: and asg.person_id = p_person_id
1114: and asg.primary_flag = 'Y'
1115: and p_effective_date between