APPS.CN_PSUM_PVT SQL Statements

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

Line: 120

      SELECT name
       INTO l_mgr_name
       FROM cn_srp_hr_data
        WHERE srp_id = p_mgr_id
      ;

Line: 213

          SELECT name INTO l_mgr_name FROM cn_srp_hr_data WHERE srp_id = l_srp_group_rec.salesrep_id;

Line: 383

         SELECT  RE.RESOURCE_NAME INTO l_mgr_name
         FROM JTF_RS_RESOURCE_EXTNS_VL RE, JTF_RS_SALESREPS S
         WHERE RE.RESOURCE_ID = S.RESOURCE_ID AND TO_NUMBER(S.SALESREP_ID) > 0 AND
         S.SALESREP_ID = p_mgr_id;

Line: 388

         SELECT name INTO l_mgr_name
         FROM cn_srp_hr_data
         WHERE srp_id = p_mgr_id;

Line: 483

         SELECT  RE.RESOURCE_NAME INTO l_mgr_name
         FROM JTF_RS_RESOURCE_EXTNS_VL RE, JTF_RS_SALESREPS S
         WHERE RE.RESOURCE_ID = S.RESOURCE_ID AND TO_NUMBER(S.SALESREP_ID) > 0 AND
         S.SALESREP_ID = l_srp_group_rec.salesrep_id;

Line: 488

         SELECT name INTO l_mgr_name
         FROM cn_srp_hr_data
         WHERE srp_id = l_srp_group_rec.salesrep_id;