APPS.XTR_LIMITS_P dependencies on XTR_DEAL_DATE_AMOUNTS

Line 822: from XTR_DEAL_DATE_AMOUNTS

818: select COMPANY_CODE,CPARTY_CODE,LIMIT_CODE,LIMIT_PARTY,AMOUNT_DATE,AMOUNT,
819: HCE_AMOUNT,DEALER_CODE,DEAL_NUMBER,DEAL_TYPE,
820: TRANSACTION_NUMBER,DEAL_SUBTYPE,PORTFOLIO_CODE,STATUS_CODE,
821: PRODUCT_TYPE,CURRENCY
822: from XTR_DEAL_DATE_AMOUNTS
823: where LIMIT_CODE is NOT NULL
824: and STATUS_CODE = 'CURRENT'
825: and ((AMOUNT_DATE >= trunc(sysdate) and DEAL_TYPE NOT IN('ONC','CMF')) or
826: (AMOUNT_DATE >= trunc(sysdate) and DEAL_TYPE IN('ONC','CMF')

Line 1542: from XTR_DEAL_DATE_AMOUNTS A,

1538: cursor c_get_util(pc1_company_code VARCHAR2,pc1_limit_party VARCHAR2,
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'