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_I_PARTIES_H

Line 1409: From CSI_I_PARTIES_H csh,

1405:
1406: Cursor pty_hist_csr (p_from_trans IN NUMBER,
1407: p_to_trans IN NUMBER) IS
1408: Select csh.*
1409: From CSI_I_PARTIES_H csh,
1410: CSI_TRANSACTIONS csit
1411: Where csit.transaction_id between p_from_trans and p_to_trans --Bug 8836533
1412: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
1413: And csh.transaction_id = csit.transaction_id;

Line 1426: Where object_name = 'CSI_I_PARTIES_H';

1422: Begin
1423: Select object_id
1424: Into l_table_id
1425: From csi_object_dictionary
1426: Where object_name = 'CSI_I_PARTIES_H';
1427: Exception
1428: When no_data_found Then
1429: l_table_id := 2;
1430: When others Then

Line 1791: Delete From CSI_I_PARTIES_H

1787: -- Purge the corresonding Archive data from the Instance history tables
1788:
1789: FORALL i IN 1 .. l_cnt
1790:
1791: Delete From CSI_I_PARTIES_H
1792: Where instance_party_history_id = l_pty_hist_rec_tab.instance_party_history_id(i);
1793:
1794: End If; -- if l_cnt > 0
1795: --

Line 5931: From CSI_I_PARTIES_H csh,

5927: --
5928: Begin
5929: Select COUNT(*)
5930: Into l_temp1
5931: From CSI_I_PARTIES_H csh,
5932: CSI_TRANSACTIONS csit
5933: Where csit.transaction_id between From_trans and To_trans
5934: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
5935: And csh.transaction_id = csit.transaction_id;