DBA Data[Home] [Help]

APPS.JTF_RS_IMP_RES_PVT dependencies on PER_JOBS

Line 91: ,per_jobs job

87: FROM
88: per_all_people_f ppl
89: ,hr_all_organization_units org
90: ,per_assignments_f asg
91: ,per_jobs job
92: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645
93: -- ,per_all_people_f pep removed the table since we can get the work_telephone from ppl
94: ,per_all_people_f emp
95: WHERE ppl.person_id = l_person_id

Line 150: ,per_jobs job

146: FROM
147: per_all_people_f ppl
148: ,hr_all_organization_units org
149: ,per_assignments_f asg
150: ,per_jobs job
151: ,hr_locations_all loc -- Changed to hr_locations_all for performance fix bug # 4956645
152: -- ,per_all_people_f pep removed the table since we can get the work_telephone from ppl
153: ,per_all_people_f emp
154: WHERE ppl.person_id = l_person_id