DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on HR_LOCATIONS_ALL

Line 639: from per_all_assignments_f asg,hr_locations_all loc

635: select asg.assignment_id,
636: asg.organization_id,
637: asg.payroll_id,
638: loc.region_2
639: from per_all_assignments_f asg,hr_locations_all loc
640: where asg.person_id = p_person_id
641: and asg.assignment_type <> 'C'
642: and asg.primary_flag = 'Y'
643: and asg.location_id = loc.location_id(+)

Line 1042: from hr_locations_all loc,per_all_assignments_f asg

1038:
1039: Cursor c_state
1040: is
1041: select region_2
1042: from hr_locations_all loc,per_all_assignments_f asg
1043: where loc.location_id = asg.location_id
1044: and asg.assignment_type <> 'C'
1045: and asg.person_id = p_person_id
1046: and asg.primary_flag = 'Y'