APPS.JA_CN_GL_BANK_EXP_REPORT_PKG SQL Statements

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

Line: 272

        SELECT PERIOD_NAME
          INTO lv_period_from
          FROM (SELECT PERIOD_NAME
                  FROM GL_PERIOD_STATUSES
                 WHERE APPLICATION_ID = 101
                   AND LEDGER_ID = pn_ledger_id
                   AND PERIOD_YEAR = pv_accounting_year
                   AND CLOSING_STATUS <> 'N'
                   AND CLOSING_STATUS <> 'F'
                 ORDER BY START_DATE ASC)
         WHERE ROWNUM = 1;

Line: 291

        SELECT PERIOD_NAME
          INTO lv_period_to
          FROM (SELECT PERIOD_NAME
                  FROM GL_PERIOD_STATUSES
                 WHERE APPLICATION_ID = 101
                   AND LEDGER_ID = pn_ledger_id
                   AND PERIOD_YEAR = pv_accounting_year
                   AND CLOSING_STATUS <> 'N'
                   AND CLOSING_STATUS <> 'F'
                 ORDER BY START_DATE DESC)
         WHERE ROWNUM = 1;

Line: 302

        SELECT TO_CHAR(END_DATE, 'YYYY/MM/DD HH:MM:SS')
          INTO lv_accounting_date
          FROM GL_PERIOD_STATUSES
         WHERE APPLICATION_ID = 101
           AND LEDGER_ID = pn_ledger_id
           AND PERIOD_NAME = lv_period_to;

Line: 346

        SELECT lookup_code
          INTO lv_gle_req_status_code
          FROM fnd_lookup_values
         WHERE lookup_type = 'CP_STATUS_CODE'
           AND view_application_id = 0
           AND security_group_id = 0
           AND meaning = lv_gle_req_status
           AND enabled_flag = 'Y'
           AND language = USERENV('LANG');

Line: 426

                SELECT lookup_code
                  INTO lv_comb_req_status_code
                  FROM fnd_lookup_values
                 WHERE lookup_type = 'CP_STATUS_CODE'
                   AND view_application_id = 0
                   AND security_group_id = 0
                   AND meaning = lv_comb_req_status --Fixing bug 9547791
                   AND enabled_flag = 'Y'
                   AND language = USERENV('LANG');