DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on HR_LOCATIONS

Line 7052: l_location_name hr_locations.location_code%type := null;

7048: (
7049: p_location_id in number
7050: ) return varchar2 is
7051:
7052: l_location_name hr_locations.location_code%type := null;
7053:
7054: cursor c_location_name is
7055: select loc.location_code
7056: from hr_locations loc

Line 7056: from hr_locations loc

7052: l_location_name hr_locations.location_code%type := null;
7053:
7054: cursor c_location_name is
7055: select loc.location_code
7056: from hr_locations loc
7057: where loc.location_id = p_location_id;
7058:
7059: begin
7060: open c_location_name;