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 754: DELETE FROM XTR_DEAL_DATE_AMOUNTS_V

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

Line 1416: FROM XTR_DEAL_DATE_AMOUNTS_V

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

Line 1605: from XTR_DEAL_DATE_AMOUNTS_V

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