In this session, we are going to see how to fetch Oracle Cloud HCM TRU and Department associated with Legal Employer SQL Text select papf . person_number , paam . assignment_number , ppnf . full_name , leg . name legal_employer , tru . name tax_reporting_unit , dep . name department , dep_leg . name dep_legal_employer from per_all_people_f papf , per_person_names_f ppnf , per_all_assignments_m paam , pay_payroll_assignments ppa , pay_dir_cards_f pdcf , pay_dir_card_definitions_vl pdccd , pay_dir_card_components_f pdccf , pay_dir_rep_cards_f pdrcf , hr_organization_v tru , hr_organization_v leg , hr_organization_v dep , hr_organization_information_f inf , hr_organization_v dep_leg where 1 = 1 -- and papf.person_number in ('0000') and papf . person_id = ppnf . person_id and papf . person_id = paam . p...