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_II_RELATIONSHIPS_H

Line 4988: From CSI_II_RELATIONSHIPS_H csh,

4984:
4985: Cursor rel_hist_csr (p_from_trans IN NUMBER,
4986: p_to_trans IN NUMBER) IS
4987: Select csh.*
4988: From CSI_II_RELATIONSHIPS_H csh,
4989: CSI_TRANSACTIONS csit
4990: Where csit.transaction_id between from_trans and to_trans
4991: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
4992: And csh.transaction_id = csit.transaction_id;

Line 5005: Where object_name = 'CSI_II_RELATIONSHIPS_H';

5001: Begin
5002: Select object_id
5003: Into l_table_id
5004: From csi_object_dictionary
5005: Where object_name = 'CSI_II_RELATIONSHIPS_H';
5006: Exception
5007: When no_data_found Then
5008: l_table_id := 9;
5009: When others Then

Line 5338: Delete From CSI_II_RELATIONSHIPS_H

5334: -- Purge the corresonding Archive data from the Instance Rel. history tables
5335:
5336: FORALL i IN 1 .. l_cnt
5337:
5338: Delete From CSI_II_RELATIONSHIPS_H
5339: Where relationship_history_id = l_rel_hist_rec_tab.relationship_history_id(i);
5340:
5341: End If; -- if l_cnt > 0
5342: --

Line 6029: From CSI_II_RELATIONSHIPS_H csh,

6025: --
6026: Begin
6027: Select COUNT(*)
6028: Into l_temp8
6029: From CSI_II_RELATIONSHIPS_H csh,
6030: CSI_TRANSACTIONS csit
6031: Where csit.transaction_id between From_trans and To_trans
6032: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
6033: And csh.transaction_id = csit.transaction_id;