APPS.XTR_LIMITS_P dependencies on XTR_COUNTERPARTY_LIMITS

Line 1478: FROM xtr_counterparty_limits cl, xtr_parties_v p

1474: --
1475: cursor c_get_util (pc1_company_code VARCHAR2,pc1_cparty_code VARCHAR2,
1476: pc1_limit_code VARCHAR2) is
1477: SELECT nvl(cl.limit_amount,0), nvl(cl.utilised_amount,0)
1478: FROM xtr_counterparty_limits cl, xtr_parties_v p
1479: WHERE cl.company_code = pc1_company_code
1480: AND cl.cparty_code = pc1_cparty_code
1481: AND cl.limit_code = pc1_limit_code
1482: AND cl.limit_code <> 'SETTLE'

Line 1543: XTR_COUNTERPARTY_LIMITS B,

1539: pc1_amount_date date) is
1540: select nvl(max(B.LIMIT_AMOUNT),0) LIMIT_AMT,
1541: nvl(sum(round(abs(A.CASHFLOW_AMOUNT) / M.HCE_RATE,0)),0) UTILISED
1542: from XTR_DEAL_DATE_AMOUNTS A,
1543: XTR_COUNTERPARTY_LIMITS B,
1544: XTR_MASTER_CURRENCIES M
1545: where A.ACTUAL_SETTLEMENT_DATE = pc1_amount_date
1546: and A.SETTLE = 'Y'
1547: and A.COMPANY_CODE = pc1_company_code

Line 1570: from XTR_COUNTERPARTY_LIMITS

1566: where param_name = pc3_param_name;
1567: --
1568: cursor c_get_limit_amt(pc1_company_code VARCHAR2,pc1_limit_party VARCHAR2) is
1569: select nvl(limit_amount,0)
1570: from XTR_COUNTERPARTY_LIMITS
1571: where cparty_code = pc1_limit_party
1572: and company_code = pc1_company_code
1573: and limit_code = 'SETTLE';
1574: --

Line 1638: xtr_counterparty_limits cl,

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
1642: AND cl.company_code = s.company

Line 1675: xtr_counterparty_limits cl

1671: (v_include_payments='Y')
1672: )
1673: GROUP by a.CPARTY,a.COMPANY,nvl(a.AMOUNT_DATE,trunc(SYSDATE))
1674: ) sru,
1675: xtr_counterparty_limits cl
1676: WHERE cl.cparty_code = sru.cparty_code(+)
1677: AND cl.company_code = sru.company_code(+)
1678: AND cl.limit_code = 'SETTLE'
1679: AND nvl(sru.effective_date,trunc(sysdate)) = pc1_amount_date

Line 1691: from XTR_COUNTERPARTY_LIMITS

1687: where param_name = pc3_param_name;
1688: --
1689: cursor c_get_limit_amt(pc1_company_code VARCHAR2,pc1_limit_party VARCHAR2) is
1690: select nvl(limit_amount,0)
1691: from XTR_COUNTERPARTY_LIMITS
1692: where cparty_code = pc1_limit_party
1693: and company_code = pc1_company_code
1694: and limit_code = 'SETTLE'
1695: and limit_amount <> 0;

Line 1828: update xtr_COUNTERPARTY_LIMITS_V

1824: delete from xtr_MIRROR_DDA_LIM_ROW_TMP_V;
1825: --
1826: update xtr_COMPANY_LIMITS_V
1827: set UTILISED_AMOUNT = 0;
1828: update xtr_COUNTERPARTY_LIMITS_V
1829: set UTILISED_AMOUNT = 0;
1830: update xtr_MASTER_CURRENCIES
1831: set UTILISED_AMOUNT = 0;
1832: update xtr_COUNTRY_COMPANY_LIMITS_V