APPS.PON_PONXFEDOPPS_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 62: FROM hr_locations_all hrall, hr_location_extra_info loceit

58:
59: if p_issue_office is not null then
60: select hrall.location_code
61: into issue_office_desc
62: FROM hr_locations_all hrall, hr_location_extra_info loceit
63: WHERE loceit.location_id = hrall.location_id
64: and loceit.information_type = 'CLM_OFFICE_CODE'
65: and po_uda_data_util.is_location_valid(hrall.location_id, 'ISSUING_OFFICE') = 'Y'
66: and hrall.location_id = p_issue_office;