APPS.XTR_XTROHINS_XMLP_PKG dependencies on XTR_HEDGE_RELATIONSHIPS

Line 471: XTR_HEDGE_RELATIONSHIPS HR,

467: CURSOR ALLOC IS
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'

Line 609: XTR_HEDGE_RELATIONSHIPS R

605: CURSOR REF_AMT(P_FLAG IN VARCHAR2) IS
606: SELECT
607: ABS(SUM(R.REFERENCE_AMOUNT)) REF_AMT
608: FROM
609: XTR_HEDGE_RELATIONSHIPS R
610: WHERE R.HEDGE_ATTRIBUTE_ID = HEDGE_NO
611: AND INSTRUMENT_ITEM_FLAG = P_FLAG;
612: BEGIN
613: OPEN HDG;