APPS.PSA_MF_CREATE_DISTRIBUTIONS SQL Statements

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

Line: 37

	 SELECT trx.customer_trx_id
         FROM   ra_customer_trx trx, psa_trx_types_all psa
         WHERE  trx.customer_trx_id   = nvl(cust_trx_id,trx.customer_trx_id)
         AND    trx.cust_trx_type_id  = psa.psa_trx_type_id
         AND    set_of_books_id       = p_set_of_books_id;

Line: 46

       SELECT b.receivable_application_id
       FROM  ar_receivable_applications b
       WHERE b.applied_customer_trx_id = cust_trx_id ;

Line: 52

       SELECT c.adjustment_id
       FROM   ar_Adjustments c
       WHERE  c.customer_trx_id = cust_trx_id;

Line: 58

       SELECT cash_receipt_id,receipt_method_id,receivables_trx_id
       FROM   ar_cash_receipts arc, psa_receivables_trx_all psa
       WHERE  arc.cash_receipt_id     = NVL(c_cash_receipt_id, arc.cash_receipt_id)
       AND    arc.receivables_trx_id  = psa.psa_receivables_trx_id
       AND    arc.set_of_books_id     = p_set_of_books_id;

Line: 112

         SELECT psa_mf_error_log_s.NEXTVAL INTO run_num
         FROM sys.dual;

Line: 493

  CURSOR c_selected_trx IS
   SELECT distinct trx.customer_trx_id document_id
   FROM   ra_customer_trx trx,
 	  psa_trx_types_all psa,
	  ra_cust_trx_line_gl_dist gd
   WHERE  trx.cust_trx_type_id  = psa.psa_trx_type_id
   AND    trx.set_of_books_id   = p_set_of_books_id
   AND    trx.customer_trx_id   = gd.customer_trx_id
   AND    gd.gl_date between nvl(p_gl_date_from, gd.gl_date) and nvl(p_gl_date_to, gd.gl_date);

Line: 508

  OPEN c_selected_trx;

Line: 510

  FETCH c_selected_trx BULK COLLECT INTO l_trx_id_tab;

Line: 512

  CLOSE c_selected_trx;