APPS.POS_COMPARE_REVISIONS dependencies on HR_LOCATIONS

Line 433: * HR_LOCATIONS table.

429: * Resolves the location code
430: *
431: * ARGUMENTS
432: * p_location_id Unique identifier for the location in
433: * HR_LOCATIONS table.
434: *
435: * NOTES
436: * Return NULL if no matching records were found.
437: *

Line 445: v_location_code hr_locations.location_code%TYPE;

441: ********************************************************************/
442: FUNCTION get_location( p_location_id IN NUMBER )
443: RETURN VARCHAR2 AS
444:
445: v_location_code hr_locations.location_code%TYPE;
446: v_progress varchar2(3);
447:
448: BEGIN
449:

Line 454: FROM hr_locations_all

450: v_progress := '090';
451:
452: SELECT location_code
453: INTO v_location_code
454: FROM hr_locations_all
455: WHERE location_id = p_location_id;
456:
457: RETURN v_location_code;
458: