DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on HR_LOCATIONS_ALL

Line 656: from per_all_assignments_f asg,hr_locations_all loc

652: select asg.assignment_id,
653: asg.organization_id,
654: asg.payroll_id,
655: loc.region_2
656: from per_all_assignments_f asg,hr_locations_all loc
657: where asg.person_id = p_person_id
658: and asg.assignment_type <> 'C'
659: and asg.primary_flag = 'Y'
660: and asg.location_id = loc.location_id(+)

Line 1059: from hr_locations_all loc,per_all_assignments_f asg

1055:
1056: Cursor c_state
1057: is
1058: select region_2
1059: from hr_locations_all loc,per_all_assignments_f asg
1060: where loc.location_id = asg.location_id
1061: and asg.assignment_type <> 'C'
1062: and asg.person_id = p_person_id
1063: and asg.primary_flag = 'Y'