DBA Data[Home] [Help]

APPS.BEN_PEN_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 2359: from hr_locations_all loc,per_all_assignments_f asg

2355: ) is
2356:
2357: Cursor c_state is
2358: select loc.region_2, asg.assignment_id, asg.organization_id
2359: from hr_locations_all loc,per_all_assignments_f asg
2360: where loc.location_id(+) = asg.location_id
2361: and asg.person_id = p_person_id
2362: and asg.assignment_type <> 'C'
2363: and asg.primary_flag = 'Y'

Line 2883: from per_all_assignments_f

2879: ,p_include_erl in varchar2
2880: ) is
2881: cursor c_paf is
2882: select assignment_id
2883: from per_all_assignments_f
2884: where person_id = p_person_id
2885: and assignment_type <> 'C'
2886: and primary_flag = 'Y'
2887: and p_effective_date between