DBA Data[Home] [Help]

APPS.BEN_PEN_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 2358: from hr_locations_all loc,per_all_assignments_f asg

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

Line 2882: from per_all_assignments_f

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