APPS.PAY_AE_SOE dependencies on PER_ALL_ASSIGNMENTS_F

Line 26: ,per_all_assignments_f asg

22: ,hl1.meaning ||'' ''|| peo.full_name COL12
23: , decode(peo.per_information3,peo.per_information3,peo.per_information3||'' '',null) || decode(peo.per_information4,peo.per_information4,peo.per_information4||'' '',null)
24: || decode(peo.per_information5,peo.per_information5,peo.per_information5||'' '',null) || decode(peo.per_information6,peo.per_information6,peo.per_information6||'' '',null) COL14
25: from per_all_people_f peo
26: ,per_all_assignments_f asg
27: ,hr_all_organization_units_vl org
28: ,per_jobs_vl job
29: ,per_all_positions pos
30: ,hr_locations loc

Line 221: FROM per_all_people_f person, per_all_assignments_f asg

217: and pa.effective_date >= l_earliest_ctx_date;
218: --
219: cursor getNationality IS
220: SELECT person.per_information18
221: FROM per_all_people_f person, per_all_assignments_f asg
222: WHERE person.person_id = asg.person_id
223: AND asg.assignment_id = l_assignment_id
224: AND trunc(l_effective_date,'MM') between trunc(asg.effective_start_date,'MM') and asg.effective_end_date
225: AND trunc(l_effective_date,'MM') between trunc(person.effective_start_date,'MM') and person.effective_end_date;