APPS.PO_POXAWDSTA_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 91: FROM hr_locations_all hrall, hr_location_extra_info loceit

87:
88: if p_issue_office is not null then
89: select hrall.location_code
90: into issue_office_desc
91: FROM hr_locations_all hrall, hr_location_extra_info loceit
92: WHERE loceit.location_id = hrall.location_id
93: and loceit.information_type = 'CLM_OFFICE_CODE'
94: and po_uda_data_util.is_location_valid(hrall.location_id, 'ISSUING_OFFICE') = 'Y'
95: and hrall.location_id = p_issue_office;