APPS.JA_CN_PS_FA_EXP_PKG SQL Statements

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

Line: 405

        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)
         WHERE ROWNUM = 1;

Line: 427

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

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

SELECT
  context_code
, attribute_column
FROM
  ja_cn_dff_assignments_v
WHERE chart_of_accounts_id = pn_coa_id
  AND (lookup_code = 'FAAU' OR lookup_code = 'FAUM');

Line: 754

    SELECT
      COUNT(*)
    INTO
      ln_row_count
    FROM
      ja_cn_dep_meth_assignment
     WHERE legal_entity_id = pn_legal_entity_id;