APPS.JTF_TERR_NAMEACC_PUB SQL Statements

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

Line: 110

       Select distinct party_name
       into x_party_name
       from HZ_PARTIES
       where party_id = p_party_id;

Line: 221

         SELECT jtf_terr_results_s.nextval into x_session_id FROM sys.dual;

Line: 227

     SELECT TA.NAME
     INTO l_terr_group_name
     FROM JTF_TERR TA,
          JTF_TERR TA2
     WHERE
          TA.TERR_ID = TA2.PARENT_TERRITORY_ID
     AND  TA2.TERR_ID = lx_winners_rec.terr_id(i);

Line: 238

     SELECT ROLE_NAME
     INTO l_role_name
     FROM JTF_RS_ROLES_VL
     WHERE ROLE_CODE = lx_winners_rec.role(i);

Line: 245

     INSERT INTO JTF_TAE_RPT_STAGING_OUT(
           TRANS_OBJECT_ID,
           TRANS_DETAIL_OBJECT_ID,
           TRANS_OBJECT_TYPE_ID,
           SOURCE_ID,
           SESSION_ID,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATE_LOGIN,
           TERR_ID,
           TERR_RANK,
           RESOURCE_ID,
           RESOURCE_TYPE,
           GROUP_ID,
           ROLE,
           RESOURCE_NAME,
           AT_CHAR01,
           AT_CHAR02,
           AT_CHAR03,
           AT_CHAR04,
           AT_CHAR05,
           AT_CHAR06,
           AT_CHAR07
          ) VALUES (
          lx_winners_rec.trans_object_id(i),
          nvl(lx_winners_rec.trans_detail_object_id(i), -1),
          -1,
          -1, --p_source_id,
          x_session_id,
          SYSDATE,
          -1,
          -1,
          SYSDATE,
          -1,
          lx_winners_rec.terr_id(i),
          lx_winners_rec.absolute_rank(i),
          lx_winners_rec.resource_id(i),
          lx_winners_rec.resource_type(i),
          lx_winners_rec.group_id(i),
          lx_winners_rec.role(i),
          lx_winners_rec.resource_name(i),
          lx_winners_rec.resource_job_title(i),
          lx_winners_rec.resource_phone(i),
          lx_winners_rec.resource_email(i),
          lx_winners_rec.resource_mgr_name(i),
          lx_winners_rec.resource_mgr_phone(i),
          l_role_name,
          lx_winners_rec.resource_mgr_email(i)
          );