1050: else
1051: per_addr.country
1052: end
1053: end COUNTRY
1054: FROM HR_LOCATIONS per_loc,
1055: PER_ADDRESSES per_addr,
1056: PER_ALL_ASSIGNMENTS_F per_assgn,
1057: PER_ADDRESSES per_addr_prov,
1058: (SELECT distinct papf1.person_id, papf1.national_identifier