APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on HR_LOCATIONS_ALL
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