eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_REPLICATE_BANK_BALANCES dependencies on XTR_DEAL_DATE_AMOUNTS_V

Line 756: DELETE FROM XTR_DEAL_DATE_AMOUNTS_V

752: CLOSE c_chk_dda_lock;
753:
754: IF c_bal_settled%FOUND THEN
755:
756: DELETE FROM XTR_DEAL_DATE_AMOUNTS_V
757: WHERE DEAL_TYPE = 'CA'
758: AND AMOUNT_TYPE = 'INTSET'
759: AND ACCOUNT_NO = p_balance_rec.account_number
760: AND CURRENCY = l_ccy

Line 1418: FROM XTR_DEAL_DATE_AMOUNTS_V

1414:
1415: -- To check whether the 'BAL' row exists in DDA table
1416: CURSOR C_BAL_EXISTS IS
1417: SELECT 'Y'
1418: FROM XTR_DEAL_DATE_AMOUNTS_V
1419: WHERE ACCOUNT_NO = p_account_number
1420: AND COMPANY_CODE = nvl(l_cross_ref,p_company_code)
1421: AND CURRENCY = l_ccy
1422: AND AMOUNT_DATE = p_balance_date

Line 1607: from XTR_DEAL_DATE_AMOUNTS_V

1603: WHERE ce_bank_account_id = p_ce_bank_account_id;
1604:
1605: cursor INT_SETTLED is
1606: select 'Y'
1607: from XTR_DEAL_DATE_AMOUNTS_V
1608: where DEAL_TYPE = 'CA'
1609: and AMOUNT_TYPE = 'INTSET'
1610: and ACCOUNT_NO = l_account_number
1611: and CURRENCY = l_currency