DBA Data[Home] [Help]

APPS.JTF_RS_IMP_RES_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 89: ,hr_all_organization_units org

85: ,ppl.internal_location
86: ,ppl.mailstop
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

Line 148: ,hr_all_organization_units org

144: ,ppl.internal_location
145: ,ppl.mailstop
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

Line 411: hr_all_organization_units o,

407: per.person_last_name last_name
408: FROM ap_suppliers P,
409: ap_supplier_contacts c,
410: ap_supplier_sites_all s,
411: hr_all_organization_units o,
412: hz_parties per,
413: hz_parties rel
414: WHERE c.vendor_contact_id = l_person_id
415: and c.vendor_site_id = s.vendor_site_id