APPS.CE_AUTO_BANK_UNREC SQL Statements

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

Line: 34

    /* 2738067 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: 66

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

Line: 70

    /*  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: 149

        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: 165

                    select RECON_ACCOUNTING_FLAG
                    into l_recon_accounting_flag
                    from ap_system_parameters_all asp
                    where asp.org_id = C_rec.org_id ;

Line: 193

                        SELECT   count(1)
                          INTO   l_count_ap_ar                      /* 13644150: count for ap/ar period */
                          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: 212

                    SELECT   count(1)
                      INTO   l_count
                      FROM   gl_period_statuses glp,
                             ce_system_parameters sys,
                             ce_bank_accounts  ba
                     WHERE  glp.application_id = 101
                     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: 249

                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: 261

                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;