APPS.JL_JGZZGLTRB_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        C.ACCTG_ENVIRONMENT_CODE
      FROM
        GL_LEDGERS L,
        GL_LEDGER_CONFIGURATIONS C
      WHERE L.LEDGER_ID = P_LEDGER_ID
        AND C.CONFIGURATION_ID = L.CONFIGURATION_ID;

Line: 13

      SELECT
        CD.OBJECT_ID
      FROM
        GL_LEDGERS L,
        GL_LEDGER_CONFIG_DETAILS CD
      WHERE L.LEDGER_ID = P_LEDGER_ID
        AND CD.CONFIGURATION_ID = L.CONFIGURATION_ID
        AND CD.OBJECT_TYPE_CODE = 'LEGAL_ENTITY';

Line: 30

    SELECT
      RELEASE_NAME
    INTO L_VERSION
    FROM
      FND_PRODUCT_GROUPS;

Line: 36

    SELECT
      TO_CHAR(SYSDATE
             ,'YYYY-MM-DD') || 'T' || TO_CHAR(SYSDATE
             ,'HH24:MI:SS')
    INTO REPORT_EXEC_DATE
    FROM
      DUAL;

Line: 43

    SELECT
      NAME,
      CHART_OF_ACCOUNTS_ID,
      PERIOD_SET_NAME,
      ACCOUNTED_PERIOD_TYPE
    INTO DATA_ACCESS_SET_NAME,COA_ID,L_PERIOD_SET_NAME,L_PERIOD_TYPE
    FROM
      GL_ACCESS_SETS
    WHERE ACCESS_SET_ID = P_ACCESS_SET_ID;

Line: 52

    SELECT
      NVL(LR.TARGET_LEDGER_NAME
         ,L.NAME)
    INTO PARAM_LEDGER_NAME
    FROM
      GL_LEDGERS L,
      GL_LEDGER_RELATIONSHIPS LR
    WHERE L.LEDGER_ID = P_LEDGER_ID
      AND LR.APPLICATION_ID (+) = 101
      AND LR.SOURCE_LEDGER_ID (+) = L.LEDGER_ID
      AND LR.TARGET_LEDGER_ID (+) = L.LEDGER_ID
      AND LR.TARGET_CURRENCY_CODE (+) = P_LEDGER_CURRENCY;

Line: 64

    SELECT
      P1.PERIOD_YEAR,
      P1.START_DATE,
      P2.END_DATE,
      TO_CHAR(P1.START_DATE
             ,'YYYY-MM-DD') || 'T' || TO_CHAR(P1.START_DATE
             ,'HH24:MI:SS'),
      TO_CHAR(P2.END_DATE
             ,'YYYY-MM-DD') || 'T' || TO_CHAR(P2.END_DATE
             ,'HH24:MI:SS')
    INTO L_PERIOD_YEAR,PER_FROM_START_DATE,PER_TO_END_DATE,PERIOD_FROM_START_DATE,PERIOD_TO_END_DATE
    FROM
      GL_PERIODS P1,
      GL_PERIODS P2
    WHERE P1.PERIOD_SET_NAME = L_PERIOD_SET_NAME
      AND P1.PERIOD_NAME = P_PERIOD_FROM
      AND P2.PERIOD_SET_NAME = L_PERIOD_SET_NAME
      AND P2.PERIOD_NAME = P_PERIOD_TO;

Line: 82

    SELECT
      P1.PERIOD_NAME,
      P1.ADJUSTMENT_PERIOD_FLAG
    INTO FIRST_PERIOD_NAME,FIRST_PERIOD_ADJ_FLAG
    FROM
      GL_PERIODS P1
    WHERE P1.PERIOD_SET_NAME = L_PERIOD_SET_NAME
      AND P1.PERIOD_TYPE = L_PERIOD_TYPE
      AND P1.PERIOD_YEAR = L_PERIOD_YEAR
      AND P1.PERIOD_NUM = (
      SELECT
        MIN(P2.PERIOD_NUM)
      FROM
        GL_PERIODS P2
      WHERE P2.PERIOD_SET_NAME = L_PERIOD_SET_NAME
        AND P2.PERIOD_TYPE = L_PERIOD_TYPE
        AND P2.PERIOD_YEAR = L_PERIOD_YEAR );

Line: 112

      SELECT_LE := TO_CHAR(L_EXC_LE_ID);

Line: 116

      SELECT_LE := 'lnsv.LEGAL_ENTITY_ID';

Line: 120

      SELECT_LE := 'NULL';

Line: 162

      SELECT
        FS.FLEX_VALUE_SET_ID
      INTO ACCT_SEG_VALUE_SET_ID
      FROM
        FND_SEGMENT_ATTRIBUTE_VALUES SAV,
        FND_ID_FLEX_SEGMENTS FS
      WHERE SAV.APPLICATION_ID = 101
        AND SAV.ID_FLEX_CODE = 'GL#'
        AND SAV.ID_FLEX_NUM = COA_ID
        AND SAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
        AND SAV.ATTRIBUTE_VALUE = 'Y'
        AND FS.APPLICATION_COLUMN_NAME = SAV.APPLICATION_COLUMN_NAME
        AND FS.APPLICATION_ID = 101
        AND FS.ID_FLEX_CODE = 'GL#'
        AND FS.ID_FLEX_NUM = COA_ID
        AND FS.ENABLED_FLAG = 'Y';

Line: 184

      WHERE_DEGREE := 'and EXISTS (select 1' || ' from FND_FLEX_VALUES_VL parent' || ' where parent.flex_value_set_id = ' || TO_CHAR(ACCT_SEG_VALUE_SET_ID) || ' and substr(' || SELECT_ACCT_SEG
      || ', 1, length(parent.flex_value)) = parent.flex_value' || ' and gcc.summary_flag = ''N''' || ' and length(parent.flex_value) > 1';

Line: 187

        WHERE_DEGREE := WHERE_DEGREE || ' and (substr(parent.flex_value, 1, 1) in (''1'',''2'',''3'',''4'',''5'') or parent.flex_value = ''88'')' || ' and substr(' || SELECT_ACCT_SEG
        || ', 1, 1) in (''1'',''2'',''3'',''4'',''5'',''8'') )';

Line: 190

        WHERE_DEGREE := WHERE_DEGREE || ' and substr(parent.flex_value, 1, 1) in (''1'',''2'',''3'',''4'',''5'',''8'')' || ' and substr(' || SELECT_ACCT_SEG || ', 1, 1) in (''1'',''2'',''3'',''4'',''5'',''8''))';

Line: 192

        WHERE_DEGREE := WHERE_DEGREE || ' and substr(parent.flex_value, 1, 1) in (''6'',''7'',''8'') and substr(parent.flex_value, 1, 2) <> ''88''' || ' and substr(' || SELECT_ACCT_SEG
        || ', 1, 1) in (''6'',''7'',''8''))';

Line: 212

    SELECT
      MIN(MEANING)
    INTO PARAM_CURRENCY_TYPE
    FROM
      GL_LOOKUPS
    WHERE LOOKUP_TYPE = 'GL_CURRENCY_TYPE'
      AND LOOKUP_CODE = P_CURRENCY_TYPE;

Line: 219

    SELECT
      MIN(MEANING)
    INTO PARAM_ZERO_BEGIN_YEAR_BAL
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'YES/NO'
      AND LOOKUP_CODE = P_ZERO_BYB;

Line: 226

    SELECT
      MIN(MEANING)
    INTO PARAM_ACCT_CLASS
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'JGZZ_ACCOUNT_CLASS'
      AND LOOKUP_CODE = P_ACCT_CLASS;

Line: 233

    SELECT
      MIN(MEANING)
    INTO PARAM_REPORT_TYPE
    FROM
      FND_LOOKUPS
    WHERE LOOKUP_TYPE = 'JGZZ_GL_TB_TYPE'
      AND LOOKUP_CODE = P_REPORT_TYPE;

Line: 531

      SELECT
        LEGAL_ENTITY_ID,
        NAME,
        LTRIM(ADDRESS_LINE_1),
        LTRIM(ADDRESS_LINE_2),
        LTRIM(ADDRESS_LINE_3),
        LTRIM(TOWN_OR_CITY),
        LTRIM(POSTAL_CODE),
        ACTIVITY_CODE,
        REGISTRATION_NUMBER
      FROM
        XLE_FIRSTPARTY_INFORMATION_V
      WHERE LEGAL_ENTITY_ID = V_LE_ID;

Line: 694

  FUNCTION SELECT_ACCT_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ACCT_SEG;

Line: 697

  END SELECT_ACCT_SEG_P;

Line: 699

  FUNCTION SELECT_BAL_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_BAL_SEG;

Line: 702

  END SELECT_BAL_SEG_P;

Line: 704

  FUNCTION SELECT_CC_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_CC_SEG;

Line: 707

  END SELECT_CC_SEG_P;

Line: 709

  FUNCTION SELECT_IC_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_IC_SEG;

Line: 712

  END SELECT_IC_SEG_P;

Line: 714

  FUNCTION SELECT_MGT_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_MGT_SEG;

Line: 717

  END SELECT_MGT_SEG_P;

Line: 719

  FUNCTION SELECT_ST_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ST_SEG;

Line: 722

  END SELECT_ST_SEG_P;

Line: 779

  FUNCTION SELECT_ACCOUNT_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ACCOUNT;

Line: 782

  END SELECT_ACCOUNT_P;

Line: 894

  FUNCTION SELECT_LE_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_LE;

Line: 897

  END SELECT_LE_P;