APPS.AMS_RESOURCE_PVT SQL Statements

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

Line: 24

     SELECT count(*) INTO l_count FROM JTF_RS_RESOURCE_EXTNS A,JTF_RS_RESOURCE_EXTNS_TL B
     WHERE A.source_name = l_source_name and B.resource_name = l_resource_name
     and A.resource_id = B.resource_id
     and A.user_name = l_user_name;

Line: 68

     select 'X' into l_user_name from dual;

Line: 70

      SELECT A.resource_id INTO l_resource_id
      FROM JTF_RS_RESOURCE_EXTNS A,JTF_RS_RESOURCE_EXTNS_TL B
      WHERE A.source_name = l_source_name and B.resource_name = l_resource_name
      and A.resource_id = B.resource_id  and A.user_name = l_user_name
      and rownum < 2;