APPS.IEM_RESOURCE_PVT SQL Statements

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

Line: 22

        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: 66

        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;