APPS.JA_CN_PS_GL_EXPORT_PROG SQL Statements

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

Line: 423

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

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

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

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

            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');