DBA Data[Home] [Help]

APPS.XTR_XTROHINS_XMLP_PKG dependencies on XTR_HEDGE_ATTRIBUTES

Line 472: XTR_HEDGE_ATTRIBUTES HA

468: SELECT
469: SUM(CUR_PCT_ALLOCATION)
470: FROM
471: XTR_HEDGE_RELATIONSHIPS HR,
472: XTR_HEDGE_ATTRIBUTES HA
473: WHERE HR.HEDGE_ATTRIBUTE_ID = HA.HEDGE_ATTRIBUTE_ID
474: AND PRIMARY_CODE = DEAL_NO_1
475: AND INSTRUMENT_ITEM_FLAG = 'U'
476: AND START_DATE <= P_AS_OF_DATE_1

Line 602: XTR_HEDGE_ATTRIBUTES H

598: S.HEDGE_APPROACH,
599: H.HEDGE_AMOUNT
600: FROM
601: XTR_HEDGE_STRATEGIES S,
602: XTR_HEDGE_ATTRIBUTES H
603: WHERE S.STRATEGY_CODE = H.STRATEGY_CODE
604: AND H.HEDGE_ATTRIBUTE_ID = HEDGE_NO;
605: CURSOR REF_AMT(P_FLAG IN VARCHAR2) IS
606: SELECT