APPS.JTF_RS_INTEGRATION_PUB SQL Statements

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

Line: 19

   SELECT  group_id
   INTO    l_group_id
   FROM    jtf_rs_srp_groups
   WHERE   salesrep_id = p_salesrep_id
   AND     nvl(org_id,-99)  = nvl(p_org_id,-99)
   AND     l_date BETWEEN start_date AND end_date;

Line: 65

 l_select         varchar2(300);

Line: 80

   l_select :=   'SELECT distinct resource_id from jtf_rs_resource_skills ';

Line: 183

   l_query := l_select || l_where;