DBA Data[Home] [Help]

APPS.PAYRPENP dependencies on HR_LOCATIONS

Line 135: from hr_locations loc

131: RETURN VARCHAR2 IS
132:
133: cursor c_get_location_code is
134: select loc.location_code
135: from hr_locations loc
136: where loc.location_id = p_location_id;
137:
138: l_location_code hr_locations.location_code%TYPE;
139:

Line 138: l_location_code hr_locations.location_code%TYPE;

134: select loc.location_code
135: from hr_locations loc
136: where loc.location_id = p_location_id;
137:
138: l_location_code hr_locations.location_code%TYPE;
139:
140: BEGIN
141:
142: open c_get_location_code;