DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on HR_LOCATIONS

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

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

Line 7055: from hr_locations loc

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