APPS.PO_COMPARE_REVISIONS dependencies on HR_LOCATIONS

Line 372: * HR_LOCATIONS table.

368: * Resolves the location code
369: *
370: * ARGUMENTS
371: * p_location_id Unique identifier for the location in
372: * HR_LOCATIONS table.
373: *
374: * NOTES
375: * Return NULL if no matching records were found.
376: *

Line 384: v_location_code hr_locations.location_code%TYPE;

380: ********************************************************************/
381: FUNCTION get_location( p_location_id IN NUMBER )
382: RETURN VARCHAR2 AS
383:
384: v_location_code hr_locations.location_code%TYPE;
385: v_progress varchar2(3);
386:
387: BEGIN
388:

Line 393: FROM hr_locations

389: v_progress := '090';
390:
391: SELECT location_code
392: INTO v_location_code
393: FROM hr_locations
394: WHERE location_id = p_location_id;
395:
396: RETURN v_location_code;
397: