APPS.XTR_LIMITS_P dependencies on XTR_SETTLEMENTS_V

Line 1637: FROM xtr_settlements_v s,

1633: cursor c_get_util_future(pc1_company_code VARCHAR2,pc1_limit_party VARCHAR2,
1634: pc1_amount_date date) is
1635: SELECT nvl(max(cl.limit_amount),0),
1636: nvl(sum(round(abs(s.cashflow_amount)/mc.hce_rate,0)),0)
1637: FROM xtr_settlements_v s,
1638: xtr_counterparty_limits cl,
1639: xtr_master_currencies mc
1640: WHERE s.amount_date > trunc(sysdate)
1641: AND cl.cparty_code = s.cparty

Line 1664: FROM XTR_SETTLEMENTS_V a, XTR_MASTER_CURRENCIES m

1660: SELECT nvl(SUM(ROUND(ABS(a.CASHFLOW_AMOUNT) / m.HCE_RATE,0)),0) UTILISED_AMOUNT,
1661: a.CPARTY CPARTY_CODE,
1662: a.COMPANY COMPANY_CODE,
1663: nvl(a.AMOUNT_DATE,TRUNC(SYSDATE)) EFFECTIVE_DATE
1664: FROM XTR_SETTLEMENTS_V a, XTR_MASTER_CURRENCIES m
1665: WHERE a.AMOUNT_DATE = trunc(SYSDATE)
1666: AND a.CASHFLOW_AMOUNT <> 0
1667: AND m.CURRENCY = a.CURRENCY
1668: AND (