DBA Data[Home] [Help]

APPS.PO_POXAWDSTA_XMLP_PKG dependencies on PO_UDA_DATA_UTIL

Line 94: and po_uda_data_util.is_location_valid(hrall.location_id, 'ISSUING_OFFICE') = 'Y'

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;
96: end if;
97:
98: RETURN (issue_office_desc);