APPS.JTF_RS_GRP_SUM_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 68

          select mem.group_id group_id,
		 grp.group_name group_name,
                 upper(grp.group_name) u_group_name,
		 grp.group_desc group_desc,
		 grp.group_number group_number,
		 grp.start_date_active start_date_active,
                 grp.end_date_active end_date_active
            from jtf_rs_group_members mem,
		 jtf_rs_groups_vl grp
           where mem.resource_id in
                     (select rsc.resource_id
		      from   jtf_rs_resource_extns rsc
		      where  rsc.user_id  = l_uid)
            and nvl(mem.delete_flag,'N') = 'N'
	    and  mem.group_id = grp.group_id
            order by u_group_name, mem.group_id  ;

Line: 88

	     select group_id,
		    group_name,
                    upper(group_name) u_group_name,
		    group_desc,
		    group_number ,
		    start_date_active,
		    end_date_active
     	      from  jtf_rs_groups_vl
	      where upper(group_name) like l_group
	      union
	     select group_id,
		    group_name,
                    upper(group_name) u_group_name,
		    group_desc,
		    group_number,
		    start_date_active,
		    end_date_active
     	      from  jtf_rs_groups_vl
	      where group_number like l_group
/*	      union
	     select group_id,
		    group_name,
                    upper(group_name) u_group_name,
		    group_desc,
		    group_number,
		    start_date_active,
		    end_date_active
     	      from  jtf_rs_groups_vl
	      where group_id = l_grp_id
*/	      order by u_group_name, group_id ;

Line: 120

             select grl.related_group_id,
		    grp.group_name,
                    upper(grp.group_name) u_group_name
             from   jtf_rs_grp_relations grl,
		    jtf_rs_groups_vl grp
             where  grl.group_id = l_par_group_id
             and    trunc(sysdate) between grl.start_date_active and nvl(grl.end_date_active,sysdate)
             and    nvl(grl.delete_flag,'N') = 'N'
             and    grl.related_group_id = grp.group_id
             order by u_group_name, grl.related_group_id ;

Line: 134

             select grl.group_id,
		    grp.group_name,
                    upper(grp.group_name) u_group_name
             from   jtf_rs_grp_relations grl,
		    jtf_rs_groups_vl grp
             where  grl.related_group_id = l_child_group_id
             and    trunc(sysdate) between grl.start_date_active and nvl(grl.end_date_active,sysdate)
             and    nvl(grl.delete_flag,'N') = 'N'
             and    grl.group_id = grp.group_id
             order by u_group_name,grl.group_id ;

Line: 184

        l_qry := ' select grp.group_id, grp.group_name, upper(grp.group_name) u_group_name, grp.group_desc, grp.group_number, grp.start_date_active, grp.end_date_active ';