APPS.CE_AUTO_BANK_UNREC SQL Statements

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

Line: 39

  Added statement_header_id to the selected fields in the cursor.*/
  CURSOR C_reconciled IS
    SELECT 	row_id, statement_header_number,
		statement_line_id,
		trx_type,
		clearing_trx_type,
		batch_id,
		trx_id,
		cash_receipt_id,
		trx_date,
		gl_date,
		status,
		cleared_date,
		amount,
		bank_errors,
		bank_charges,
		bank_account_amount,
		bank_currency_code,
		exchange_rate_type,
		exchange_rate_date,
		exchange_rate,
		statement_complete_flag,
		statement_header_id, org_id, legal_entity_id, bank_account_id
    FROM	CE_RECONCILED_TRANSACTIONS_V
    WHERE       bank_account_id		= X_bank_account_id
    AND		statement_header_number = NVL(X_statement_number,
						statement_header_number)
    AND		statement_line_id	= NVL(X_statement_line_id,
					      statement_line_id)
   order by   statement_header_number, statement_line_id ;

Line: 73

  SELECT 	RECON_OI_FLOAT_STATUS
  FROM	CE_BANK_ACCOUNTS
  WHERE BANK_ACCOUNT_ID = NVL(X_bank_account_id, P_BANK_ACCOUNT_ID);

Line: 77

/*  SELECT 	open_interface_float_status
    FROM 	CE_SYSTEM_PARAMETERS_ALL sys
    where exists ( select ACCOUNT_OWNER_ORG_ID
   			     from CE_BANK_ACCOUNTS --ACCTS_GT_V --ce_BANK_ACCOUNTS_v
     			     where bank_account_id = X_bank_account_id
  			     and ACCOUNT_OWNER_ORG_ID = sys.legal_entity_id);*/

Line: 170

	SELECT 	cesh.statement_complete_flag
	INTO	l_statement_complete_flag
	FROM    ce_statement_headers cesh
	WHERE	cesh.statement_header_id = C_rec.statement_header_id;

Line: 195

          SELECT count(1)
          INTO   l_count
          FROM   gl_period_statuses glp,
         	 ce_system_parameters sys,
		 ce_bank_accounts  ba
          WHERE  glp.application_id = l_app_id
          AND    glp.set_of_books_id = sys.set_of_books_id
          AND    glp.adjustment_period_flag = 'N'
          AND    glp.closing_status in ('O','F')
          AND    to_char(C_rec.gl_date,'YYYY/MM/DD') between to_char(glp.start_date,'YYYY/MM/DD') and to_char(glp.end_date,'YYYY/MM/DD')
	  AND    sys.legal_entity_id = ba.account_owner_org_id
	  AND	 ba.bank_account_id = C_rec.bank_account_id;

Line: 213

          SELECT count(1)
          INTO   l_count
          FROM   gl_period_statuses glp,
         	 ce_system_parameters sys
          WHERE  glp.application_id = l_app_id
          AND    glp.set_of_books_id = sys.set_of_books_id
          AND    glp.adjustment_period_flag = 'N'
          AND    glp.closing_status in ('O','F');

Line: 247

	select statement_number,status
	into l_stmt_stmt_num, l_status1
	from ce_statement_headers hd, ce_statement_lines ln
	where   C_rec.statement_line_id = ln.statement_line_id
	and ln.statement_header_id = hd.statement_header_id;

Line: 259

	select statement_number,status,hd.statement_complete_flag
	into l_trx_stmt_num,l_status2, l_next_statement_complete_flag
	from ce_statement_headers hd, ce_statement_lines ln
	where   C_rec.trx_id = ln.statement_line_id
	and ln.statement_header_id = hd.statement_header_id;