APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_GD_OR_SVC_TYP

Line 6396: l_gd_or_svc_typ_name ben_gd_or_svc_typ.name%type := null;

6392: (
6393: p_gd_or_svc_typ_id in number
6394: ) return varchar2 is
6395:
6396: l_gd_or_svc_typ_name ben_gd_or_svc_typ.name%type := null;
6397:
6398: cursor c_gd_or_svc_typ_name is
6399: select gos.name
6400: from ben_gd_or_svc_typ gos

Line 6400: from ben_gd_or_svc_typ gos

6396: l_gd_or_svc_typ_name ben_gd_or_svc_typ.name%type := null;
6397:
6398: cursor c_gd_or_svc_typ_name is
6399: select gos.name
6400: from ben_gd_or_svc_typ gos
6401: where gos.gd_or_svc_typ_id = p_gd_or_svc_typ_id;
6402:
6403: begin
6404: open c_gd_or_svc_typ_name;