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 417: hr_all_organization_units o,

413: per.email_address
414: FROM ap_suppliers P,
415: ap_supplier_contacts c,
416: ap_supplier_sites_all s,
417: hr_all_organization_units o,
418: hz_parties per,
419: hz_parties rel
420: WHERE c.vendor_contact_id = l_person_id
421: -- and c.vendor_site_id = s.vendor_site_id