APPS.XTR_XTRDDHTY_XMLP_PKG dependencies on XTR_HEDGE_RELATIONSHIPS

Line 17: XTR_HEDGE_RELATIONSHIPS HR

13: CURSOR XTR_AMT IS
14: SELECT
15: SUM(REFERENCE_AMOUNT)
16: FROM
17: XTR_HEDGE_RELATIONSHIPS HR
18: WHERE HR.INSTRUMENT_ITEM_FLAG = 'I'
19: AND HR.HEDGE_ATTRIBUTE_ID = HEDGE_NO;
20: CURSOR RECLASS IS
21: SELECT

Line 66: XTR_HEDGE_RELATIONSHIPS

62: CURSOR ITEM(P_HEDGE_NO IN NUMBER) IS
63: SELECT
64: SUM(REFERENCE_AMOUNT)
65: FROM
66: XTR_HEDGE_RELATIONSHIPS
67: WHERE HEDGE_ATTRIBUTE_ID = P_HEDGE_NO
68: AND INSTRUMENT_ITEM_FLAG = 'U';
69: L_AMOUNT NUMBER;
70: BEGIN

Line 550: XTR_HEDGE_RELATIONSHIPS R

546: CURSOR REF_AMT(P_FLAG IN VARCHAR2) IS
547: SELECT
548: ABS(SUM(R.REFERENCE_AMOUNT)) REF_AMT
549: FROM
550: XTR_HEDGE_RELATIONSHIPS R
551: WHERE R.HEDGE_ATTRIBUTE_ID = HEDGE_NO
552: AND INSTRUMENT_ITEM_FLAG = P_FLAG;
553: BEGIN
554: OPEN HDG;