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.CSI_TXN_HISTORY_PURGE_PVT dependencies on CSI_IP_ACCOUNTS_H

Line 1852: From CSI_IP_ACCOUNTS_H csh,

1848:
1849: Cursor acct_hist_csr (p_from_trans IN NUMBER,
1850: p_to_trans IN NUMBER) IS
1851: Select csh.*
1852: From CSI_IP_ACCOUNTS_H csh,
1853: CSI_TRANSACTIONS csit
1854: Where csit.transaction_id between from_trans and to_trans
1855: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
1856: And csh.transaction_id = csit.transaction_id;

Line 1869: Where object_name = 'CSI_IP_ACCOUNTS_H';

1865: Begin
1866: Select object_id
1867: Into l_table_id
1868: From csi_object_dictionary
1869: Where object_name = 'CSI_IP_ACCOUNTS_H';
1870: Exception
1871: When no_data_found Then
1872: l_table_id := 3;
1873: When others Then

Line 2219: Delete From CSI_IP_ACCOUNTS_H

2215: -- Purge the corresonding Archive data from the Instance history tables
2216:
2217: FORALL i IN 1 .. l_cnt
2218:
2219: Delete From CSI_IP_ACCOUNTS_H
2220: Where ip_account_history_id = l_acct_hist_rec_tab.ip_account_history_id(i);
2221:
2222: End If; -- if l_cnt > 0
2223: --

Line 5945: From CSI_IP_ACCOUNTS_H csh,

5941: --
5942: Begin
5943: Select COUNT(*)
5944: Into l_temp2
5945: From CSI_IP_ACCOUNTS_H csh,
5946: CSI_TRANSACTIONS csit
5947: Where csit.transaction_id between From_trans and To_trans
5948: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
5949: And csh.transaction_id = csit.transaction_id;