APPS.PO_POXAWDCCR_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 59: FROM hr_locations_all hrall, hr_location_extra_info loceit

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