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_ORG_ASSIGNMENTS_H

Line 2279: From CSI_I_ORG_ASSIGNMENTS_H csh,

2275:
2276: Cursor org_units_hist_csr (p_from_trans IN NUMBER,
2277: p_to_trans IN NUMBER) IS
2278: Select csh.*
2279: From CSI_I_ORG_ASSIGNMENTS_H csh,
2280: CSI_TRANSACTIONS csit
2281: Where csit.transaction_id between p_from_trans and p_to_trans --Bug 8836533
2282: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
2283: And csh.transaction_id = csit.transaction_id;

Line 2296: Where object_name = 'CSI_I_ORG_ASSIGNMENTS_H';

2292: Begin
2293: Select object_id
2294: Into l_table_id
2295: From csi_object_dictionary
2296: Where object_name = 'CSI_I_ORG_ASSIGNMENTS_H';
2297: Exception
2298: When no_data_found Then
2299: l_table_id := 4;
2300: When others Then

Line 2621: Delete From CSI_I_ORG_ASSIGNMENTS_H

2617: -- Purge the corresonding Archive data from the Instance history tables
2618:
2619: FORALL i IN 1 .. l_cnt
2620:
2621: Delete From CSI_I_ORG_ASSIGNMENTS_H
2622: Where instance_ou_history_id = l_org_units_hist_rec_tab.instance_ou_history_id(i);
2623:
2624:
2625: End If; -- if l_cnt > 0

Line 5959: From CSI_I_ORG_ASSIGNMENTS_H csh,

5955: --
5956: Begin
5957: Select COUNT(*)
5958: Into l_temp3
5959: From CSI_I_ORG_ASSIGNMENTS_H csh,
5960: CSI_TRANSACTIONS csit
5961: Where csit.transaction_id between From_trans and To_trans
5962: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
5963: And csh.transaction_id = csit.transaction_id;