APPS.POS_COMPARE_REVISIONS dependencies on HR_LOCATIONS

Line 429: * HR_LOCATIONS table.

425: * Resolves the location code
426: *
427: * ARGUMENTS
428: * p_location_id Unique identifier for the location in
429: * HR_LOCATIONS table.
430: *
431: * NOTES
432: * Return NULL if no matching records were found.
433: *

Line 441: v_location_code hr_locations.location_code%TYPE;

437: ********************************************************************/
438: FUNCTION get_location( p_location_id IN NUMBER )
439: RETURN VARCHAR2 AS
440:
441: v_location_code hr_locations.location_code%TYPE;
442: v_progress varchar2(3);
443:
444: BEGIN
445:

Line 450: FROM hr_locations_all

446: v_progress := '090';
447:
448: SELECT location_code
449: INTO v_location_code
450: FROM hr_locations_all
451: WHERE location_id = p_location_id;
452:
453: RETURN v_location_code;
454: