APPS.PAY_KW_SOE dependencies on PER_ALL_ASSIGNMENTS_F

Line 24: ,per_all_assignments_f asg

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

Line 217: FROM per_all_people_f person, per_all_assignments_f asg

213:
214: --
215: cursor getNationality IS
216: SELECT person.nationality
217: FROM per_all_people_f person, per_all_assignments_f asg
218: WHERE person.person_id = asg.person_id
219: AND asg.assignment_id = l_assignment_id
220: AND trunc(l_effective_date,'MM') between trunc(asg.effective_start_date,'MM') and asg.effective_end_date
221: AND trunc(l_effective_date,'MM') between trunc(person.effective_start_date,'MM') and person.effective_end_date;