APPS.CE_BNK_STMT_IMP_RPT_PKG SQL Statements

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

Line: 52

  SELECT	cbav.bank_account_num
  INTO		lc_bank_account_num
  FROM		ce_bank_accounts_v cbav
  WHERE		cbav.bank_account_id = P_BANK_ACCOUNT_ID;

Line: 65

    SELECT	cbbv.bank_branch_name
    INTO	gc_bank_branch_name
    FROM	ce_bank_branches_v cbbv
    WHERE	cbbv.branch_party_id = P_BANK_BRANCH_ID;

Line: 78

 	lc_uploaded_select_columns := ' :gc_bank_account_num BANK_ACCOUNT_NUM,
                                    :P_STATEMENT_NUM BANK_STMT_NUM';

Line: 92

	lc_uploaded_select_columns := ' :gc_bank_account_num BANK_ACCOUNT_NUM, uploaded.statement_number BANK_STMT_NUM';

Line: 102

	lc_uploaded_select_columns := ' uploaded.bank_account_num BANK_ACCOUNT_NUM
	                                , :P_STATEMENT_NUM BANK_STMT_NUM';

Line: 112

	lc_uploaded_select_columns := ' uploaded.bank_account_num BANK_ACCOUNT_NUM
	                                , uploaded.statement_number BANK_STMT_NUM';