APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_GD_OR_SVC_TYP

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

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

Line 6401: from ben_gd_or_svc_typ gos

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