APPS.CN_NOT_TRX_GRP SQL Statements

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

Line: 23

     SELECT *
       FROM cn_not_trx
     WHERE adjusted_flag = 'Y'
       AND collected_flag = 'N'
       AND (negated_flag IS NULL OR negated_flag = 'N')
	   AND org_id = p_org_id; -- Added For R12 MOAC Changes

Line: 59

         UPDATE cn_not_trx
           SET negated_flag = 'Y'
         WHERE not_trx_id = l_changed_line_rec.not_trx_id
		 AND   org_id = p_org_id; -- Added For R12 MOAC Changes