APPS.JG_JGZZGLJRB_XMLP_PKG SQL Statements

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

Line: 8

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

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

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

Line: 36

    SELECT
      NAME
    INTO DATA_ACCESS_SET_NAME
    FROM
      GL_ACCESS_SETS
    WHERE ACCESS_SET_ID = P_ACCESS_SET_ID;

Line: 42

    SELECT
      NAME
    INTO LEDGER_NAME_PARAM
    FROM
      GL_LEDGERS
    WHERE LEDGER_ID = P_LEDGER_ID;

Line: 57

      SELECT_LE := TO_CHAR(L_EXC_LE_ID);

Line: 61

      SELECT_LE := 'LNSV.LEGAL_ENTITY_ID';

Line: 63

      LE_WHERE := ' AND LNSV.LEDGER_ID (+) = ' || TO_CHAR(P_LEDGER_ID) || ' AND LNSV.SEGMENT_TYPE_CODE (+) = ''B''' || ' AND LNSV.SEGMENT_VALUE (+) = ' || SELECT_BAL_SEG || ' AND LNSV.STATUS_CODE IS NULL';

Line: 65

      SELECT_LE := ' ';

Line: 69

    SELECT
      GLP1.START_DATE,
      GLP1.EFFECTIVE_PERIOD_NUM,
      GLP2.END_DATE,
      GLP2.EFFECTIVE_PERIOD_NUM
    INTO FP_START_DATE,F_PERIOD_NUM,TP_END_DATE,T_PERIOD_NUM
    FROM
      GL_PERIOD_STATUSES GLP1,
      GL_PERIOD_STATUSES GLP2
    WHERE GLP1.APPLICATION_ID = 101
      AND GLP2.APPLICATION_ID = GLP1.APPLICATION_ID
      AND GLP1.LEDGER_ID = P_LEDGER_ID
      AND GLP2.LEDGER_ID = GLP1.LEDGER_ID
      AND GLP1.PERIOD_NAME = P_PERIOD_FROM
      AND GLP2.PERIOD_NAME = P_PERIOD_TO;

Line: 125

    SELECT_BEGIN_BAL := 'NVL(GLBAL.BEGIN_BALANCE_DR, 0) - NVL(GLBAL.BEGIN_BALANCE_CR, 0)';

Line: 128

        SELECT_BEGIN_BAL := 'DECODE(GLBAL.TRANSLATED_FLAG, ''R'', NVL(GLBAL.BEGIN_BALANCE_DR, 0) - NVL(GLBAL.BEGIN_BALANCE_CR, 0),' || 'NVL(GLBAL.BEGIN_BALANCE_DR_BEQ, 0) - NVL(GLBAL.BEGIN_BALANCE_CR_BEQ, 0))';

Line: 134

      SELECT_DR := 'DECODE(GLH.CURRENCY_CODE, ''STAT'',' || 'DECODE(NVL(GLL.STAT_AMOUNT,0),' || '0, GLL.ACCOUNTED_DR,' || 'DECODE(SIGN(NVL(GLL.STAT_AMOUNT,0)),' || '-1, GLL.ACCOUNTED_DR,' || ' 1, (NVL(GLL.ACCOUNTED_DR,0) + '
      || 'GLL.STAT_AMOUNT),' || 'GLL.ACCOUNTED_DR)),' || 'DECODE(SIGN(NVL(GLL.STAT_AMOUNT,0)),' || '1, NVL(GLL.STAT_AMOUNT,0), ' || 'NULL))';

Line: 136

      SELECT_CR := 'DECODE(GLH.CURRENCY_CODE, ''STAT'',' || 'DECODE(NVL(GLL.STAT_AMOUNT,0),' || '0, GLL.ACCOUNTED_CR,' || 'DECODE(SIGN(NVL(GLL.STAT_AMOUNT,0)),' || '-1, (NVL(GLL.ACCOUNTED_CR,0) - ' || 'GLL.STAT_AMOUNT),'
      || ' 1, GLL.ACCOUNTED_CR,' || 'GLL.ACCOUNTED_CR)),' || 'DECODE(SIGN(NVL(GLL.STAT_AMOUNT,0)),' || '-1, (0 - NVL(GLL.STAT_AMOUNT,0)), ' || 'NULL))';

Line: 140

      SELECT_DR := 'NVL(GLL.ACCOUNTED_DR, 0)';

Line: 141

      SELECT_CR := 'NVL(GLL.ACCOUNTED_CR, 0)';

Line: 144

      SELECT_DR := 'NVL(GLL.ENTERED_DR, 0)';

Line: 145

      SELECT_CR := 'NVL(GLL.ENTERED_CR, 0)';

Line: 149

      SELECT
        FLEX_VALUE_SET_ID
      INTO ACCT_SEG_VALUE_SET_ID
      FROM
        FND_ID_FLEX_SEGMENTS
      WHERE APPLICATION_ID = 101
        AND ID_FLEX_CODE = 'GL#'
        AND ID_FLEX_NUM = P_COA_ID
        AND ENABLED_FLAG = 'Y'
        AND APPLICATION_COLUMN_NAME = SUBSTR(SELECT_ACCT_SEG
            ,4);

Line: 201

    SELECT
      MEANING
    INTO CURRENCY_TYPE_PARAM
    FROM
      GL_LOOKUPS
    WHERE LOOKUP_TYPE = 'GL_CURRENCY_TYPE'
      AND LOOKUP_CODE = P_CURRENCY_TYPE;

Line: 208

    SELECT
      MEANING
    INTO BALANCE_TYPE_PARAM
    FROM
      GL_LOOKUPS
    WHERE LOOKUP_TYPE = 'BATCH_TYPE'
      AND LOOKUP_CODE = P_BALANCE_TYPE;

Line: 241

    SELECT
      NAME,
      LTRIM(ADDRESS_LINE_1),
      LTRIM(ADDRESS_LINE_2),
      LTRIM(ADDRESS_LINE_3),
      LTRIM(TOWN_OR_CITY),
      LTRIM(POSTAL_CODE),
      ACTIVITY_CODE,
      REGISTRATION_NUMBER
    INTO TEMP_LE_NAME,TEMP_ADDR1,TEMP_ADDR2,TEMP_ADDR3,TEMP_TOWN_CITY,TEMP_POSTAL_CODE,TEMP_SERVICE_TYPE,TEMP_TAX_PAYER_ID
    FROM
      XLE_FIRSTPARTY_INFORMATION_V
    WHERE LEGAL_ENTITY_ID = V_LE_ID;

Line: 643

  FUNCTION SELECT_ACCOUNT_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ACCOUNT;

Line: 646

  END SELECT_ACCOUNT_P;

Line: 648

  FUNCTION SELECT_ACCT_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ACCT_SEG;

Line: 651

  END SELECT_ACCT_SEG_P;

Line: 653

  FUNCTION SELECT_BAL_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_BAL_SEG;

Line: 656

  END SELECT_BAL_SEG_P;

Line: 703

  FUNCTION SELECT_IC_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_IC_SEG;

Line: 706

  END SELECT_IC_SEG_P;

Line: 708

  FUNCTION SELECT_MGT_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_MGT_SEG;

Line: 711

  END SELECT_MGT_SEG_P;

Line: 713

  FUNCTION SELECT_ST_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_ST_SEG;

Line: 716

  END SELECT_ST_SEG_P;

Line: 718

  FUNCTION SELECT_LE_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_LE;

Line: 721

  END SELECT_LE_P;

Line: 763

  FUNCTION SELECT_CC_SEG_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_CC_SEG;

Line: 766

  END SELECT_CC_SEG_P;

Line: 888

  FUNCTION SELECT_DR_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_DR;

Line: 891

  END SELECT_DR_P;

Line: 893

  FUNCTION SELECT_CR_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_CR;

Line: 896

  END SELECT_CR_P;

Line: 898

  FUNCTION SELECT_BEGIN_BAL_P RETURN VARCHAR2 IS
  BEGIN
    RETURN SELECT_BEGIN_BAL;

Line: 901

  END SELECT_BEGIN_BAL_P;