APPS.XTR_XTROHINS_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        SHORT_NAME
      FROM
        XTR_PARTIES_V
      WHERE PARTY_CODE = P_COMPANY;

Line: 11

      SELECT
        MEANING
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = P_TYPE
        AND LOOKUP_CODE = P_CODE;

Line: 29

      SELECT
        CP.USER_CONCURRENT_PROGRAM_NAME
      INTO REPORT_NAME
      FROM
        FND_CONCURRENT_PROGRAMS_VL CP,
        FND_CONCURRENT_REQUESTS CR
      WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
        AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
        AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;

Line: 74

      SELECT
        CP.PARAMETER_VALUE_CODE,
        DCT.USER_CONVERSION_TYPE,
        CURRENCY_CODE
      FROM
        XTR_PARTIES_V PTY,
        XTR_COMPANY_PARAMETERS CP,
        GL_SETS_OF_BOOKS SOB,
        GL_DAILY_CONVERSION_TYPES DCT
      WHERE PTY.PARTY_CODE = X_COMPANY_CODE
        AND CP.COMPANY_CODE = PTY.PARTY_CODE
        AND CP.PARAMETER_CODE = 'ACCNT_EXRTP'
        AND PTY.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
        AND CP.PARAMETER_VALUE_CODE = dct.conversion_type (+);

Line: 89

      SELECT
        MAX(CONVERSION_DATE)
      FROM
        GL_DAILY_RATES
      WHERE FROM_CURRENCY = X_BASE_CCY
        AND TO_CURRENCY = P_SOB_CCY
        AND CONVERSION_TYPE = L_CON_TYPE
        AND CONVERSION_DATE <= P_AS_OF_DATE_1;

Line: 135

      SELECT
        ITEM_NAME,
        TEXT LANG_NAME
      FROM
        XTR_SYS_LANGUAGES_VL
      WHERE MODULE_NAME = 'XTROHINS';

Line: 223

      SELECT
        MEANING
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = P_TYPE
        AND LOOKUP_CODE = P_CODE;

Line: 275

      SELECT
        NVL(M.ROUNDING_FACTOR
           ,2)
      FROM
        XTR_MASTER_CURRENCIES_V M
      WHERE M.CURRENCY = P_CURR;

Line: 282

      SELECT
        CURRENCY,
        CURRENCY_BUY,
        CURRENCY_SELL,
        BUY_AMOUNT / NVL(P_UNIT
           ,1) BUY_AMOUNT,
        SELL_AMOUNT / NVL(P_UNIT
           ,1) SELL_AMOUNT,
        FACE_VALUE_AMOUNT / NVL(P_UNIT
           ,1) FACE_VALUE_AMOUNT
      FROM
        XTR_DEALS
      WHERE DEAL_NO = DEAL_NO_1;

Line: 339

      SELECT
        CURRENCY,
        CURRENCY_BUY,
        CURRENCY_SELL
      FROM
        XTR_DEALS
      WHERE DEAL_NO = DEAL_NO_1;

Line: 347

      SELECT
        TEXT
      FROM
        XTR_SYS_LANGUAGES_VL
      WHERE MODULE_NAME = 'XTROHINS'
        AND ITEM_NAME = 'Z1IRS_NOTE';

Line: 387

      SELECT
        CURRENCY,
        CURRENCY_BUY,
        CURRENCY_SELL
      FROM
        XTR_DEALS
      WHERE DEAL_NO = DEAL_NO_1;

Line: 395

      SELECT
        CURRENCY
      FROM
        XTR_DEALS
      WHERE INT_SWAP_REF = (
        SELECT
          INT_SWAP_REF
        FROM
          XTR_DEALS
        WHERE DEAL_NO = DEAL_NO_1 )
        AND DEAL_SUBTYPE = 'INVEST'
        AND DEAL_TYPE = 'IRS';

Line: 447

      SELECT
        NVL(M.ROUNDING_FACTOR
           ,0)
      FROM
        XTR_MASTER_CURRENCIES_V M
      WHERE M.CURRENCY = P_CURR;

Line: 454

      SELECT
        CURRENCY,
        CURRENCY_BUY,
        CURRENCY_SELL,
        BUY_AMOUNT / NVL(P_UNIT
           ,1) BUY_AMOUNT,
        SELL_AMOUNT / NVL(P_UNIT
           ,1) SELL_AMOUNT,
        FACE_VALUE_AMOUNT / NVL(P_UNIT
           ,1) FACE_VALUE_AMOUNT
      FROM
        XTR_DEALS
      WHERE DEAL_NO = DEAL_NO_1;

Line: 468

      SELECT
        SUM(CUR_PCT_ALLOCATION)
      FROM
        XTR_HEDGE_RELATIONSHIPS HR,
        XTR_HEDGE_ATTRIBUTES HA
      WHERE HR.HEDGE_ATTRIBUTE_ID = HA.HEDGE_ATTRIBUTE_ID
        AND PRIMARY_CODE = DEAL_NO_1
        AND INSTRUMENT_ITEM_FLAG = 'U'
        AND START_DATE <= P_AS_OF_DATE_1
        AND ( HEDGE_STATUS IN ( 'CURRENT' , 'DESIGNATE' , 'FULFILLED' )
      OR ( HEDGE_STATUS in ( 'FAILED' , 'DEDESIGNATED' )
        AND P_AS_OF_DATE_1 <= HA.DISCONTINUE_DATE ) );

Line: 512

      SELECT
        CP.PARAMETER_VALUE_CODE,
        DCT.USER_CONVERSION_TYPE,
        CURRENCY_CODE
      FROM
        XTR_PARTIES_V PTY,
        XTR_COMPANY_PARAMETERS CP,
        GL_SETS_OF_BOOKS SOB,
        GL_DAILY_CONVERSION_TYPES DCT
      WHERE PTY.PARTY_CODE = COMPANY_CODE
        AND CP.COMPANY_CODE = PTY.PARTY_CODE
        AND CP.PARAMETER_CODE = 'ACCNT_EXRTP'
        AND PTY.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
        AND CP.PARAMETER_VALUE_CODE = dct.conversion_type (+);

Line: 558

      SELECT
        SHORT_NAME
      FROM
        XTR_PARTIES_V
      WHERE PARTY_CODE = P_COMPANY;

Line: 589

      SELECT
        SUM(RECLASS_HEDGE_AMT)
      FROM
        XTR_RECLASS_DETAILS
      WHERE HEDGE_ATTRIBUTE_ID = HEDGE_NO
        AND RECLASS_DATE <= P_DATE
        AND RECLASS_GAIN_LOSS_AMT is not null;

Line: 597

      SELECT
        S.HEDGE_APPROACH,
        H.HEDGE_AMOUNT
      FROM
        XTR_HEDGE_STRATEGIES S,
        XTR_HEDGE_ATTRIBUTES H
      WHERE S.STRATEGY_CODE = H.STRATEGY_CODE
        AND H.HEDGE_ATTRIBUTE_ID = HEDGE_NO;

Line: 606

      SELECT
        ABS(SUM(R.REFERENCE_AMOUNT)) REF_AMT
      FROM
        XTR_HEDGE_RELATIONSHIPS R
      WHERE R.HEDGE_ATTRIBUTE_ID = HEDGE_NO
        AND INSTRUMENT_ITEM_FLAG = P_FLAG;