APPS.PSA_MFAR_TRANSACTIONS SQL Statements

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

Line: 44

	  SELECT A.cust_trx_line_gl_dist_id	gl_dist_id,
		 A.code_combination_id		rev_ccid,
		 B.mf_receivables_ccid		mf_ccid,
	         B.prev_mf_receivables_ccid     prev_mf_ccid
	 FROM 	 ra_cust_trx_line_gl_dist_all 	A,
	  	 psa_mf_trx_dist_all 		B
	 WHERE 	 A.cust_trx_line_gl_dist_id	= B.cust_trx_line_gl_dist_id
	 AND 	 A.customer_trx_id		= g_cust_trx_id;

Line: 54

                (SELECT 1 FROM ra_customer_trx_lines_all x
                 WHERE x.customer_trx_line_id = A.customer_trx_line_id
                 AND NVL(extended_amount,0) <> 0);

Line: 61

	SELECT	A.rowid row_id
	 FROM	ra_customer_trx_all	A,
	  	ra_cust_trx_types_all	B
	 WHERE	A.customer_trx_id 	= g_cust_trx_id
	 AND	A.cust_trx_type_id	= B.cust_trx_type_id
                 And    (B.type = 'INV' OR B.type = 'DM')
	 FOR UPDATE;

Line: 124

	   SELECT  code_combination_id
	     INTO  g_receivables_ccid
	     FROM  ra_cust_trx_line_gl_dist_all
	     WHERE customer_trx_id = g_cust_trx_id
	     AND   account_class = 'REC'
	     AND   account_set_flag = 'N';

Line: 250

	  PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION',
	                                            g_cust_trx_id, Null, l_exception_error);

Line: 261

	  PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION',
	                                            g_cust_trx_id, Null, l_exception_error);

Line: 274

	  PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION',
	                                            g_cust_trx_id, Null, l_exception_error);

Line: 298

    SELECT cust_trx_line_gl_dist_id,
	   code_combination_id
    FROM   ra_cust_trx_line_gl_dist_all y
    WHERE  customer_trx_id  = g_cust_trx_id
    AND    account_class <> 'REC'
    AND    NOT EXISTS ( SELECT 'x'
                        FROM  psa_mf_trx_dist_all psa
			WHERE psa.cust_trx_line_gl_dist_id = y.cust_trx_line_gl_dist_id
                      );

Line: 309

           ( SELECT 1 FROM ra_customer_trx_lines_all x
             WHERE  x.customer_trx_line_id = y.customer_trx_line_id
             AND    NVL(extended_amount, 0) <> 0);

Line: 329

	-- Delete existing records if any
	--

	Delete FROM psa_mf_trx_dist_all
	WHERE  cust_trx_line_gl_dist_id In
			(SELECT	cust_trx_line_gl_dist_id
			   FROM ra_cust_trx_line_gl_dist_all
			  WHERE	customer_trx_id = g_cust_trx_id)
	AND  posting_control_id IS NULL;

Line: 341

	                              ' Generate_trx_dist --> delete from psa_mf_trx_dist_all -->'
				      || SQL%ROWCOUNT);

Line: 394

	   -- Insert into psa_mf_trx_dist_all table
	   --

	   PSA_MFAR_TRANSACTION_COVER_PKG.INSERT_ROW
	   	(X_ROWID 		    => l_rowid,
		 X_CUST_TRX_LINE_GL_DIST_ID => l_trx_gl_dist_rec.cust_trx_line_gl_dist_id,
		 X_RECEIVABLES_CCID	    => l_ccid,
		 X_PREV_MF_RECEIVABLES_CCID => l_ccid,
		 X_MODE			    => 'R');

Line: 406

	                                 ' Generate_trx_dist --> PSA_MFAR_TRANSACTION_COVER_PKG.INSERT_ROW ');

Line: 417

	  PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION',
	                                            g_cust_trx_id, Null, p_error_message);

Line: 427

	  PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION',
	                                            g_cust_trx_id, Null, p_error_message);

Line: 444

      SELECT complete_flag
      FROM   ra_customer_trx_all
      WHERE  customer_trx_id = g_cust_trx_id;

Line: 475

	  PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION', g_cust_trx_id, Null,
	  					   l_exception_error);

Line: 490

		SELECT 	count(cust_trx_line_gl_dist_id) core_count
		  FROM 	ra_cust_trx_line_gl_dist_all
		 WHERE 	customer_trx_id  = g_cust_trx_id
		   AND 	account_class <> 'REC';

Line: 496

		SELECT	count(B.cust_trx_line_gl_dist_id) mf_dist_count
		  FROM 	ra_cust_trx_line_gl_dist_all 	A,
		  	psa_mf_trx_dist_all 		B
		 WHERE 	A.cust_trx_line_gl_dist_id	= B.cust_trx_line_gl_dist_id
		   AND 	A.customer_trx_id		= g_cust_trx_id;

Line: 528

	DELETE FROM psa_mf_trx_dist_all
	WHERE  cust_trx_line_gl_dist_id Not In
	 ( SELECT cust_trx_line_gl_dist_id FROM ra_cust_trx_line_gl_dist_all );

Line: 535

	                              ' Transaction_modified --> delete psa_mf_trx_dist_all --> '
				      || SQL%ROWCOUNT);

Line: 549

	  PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'TRANSACTION',
	                                            g_cust_trx_id, Null,l_exception_error);