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_PARTY_RELATIONSHIPS_PVT dependencies on CSI_ITEM_INSTANCES_H

Line 2625: FROM CSI_ITEM_INSTANCES_H

2621: IF p_party_rec.ACTIVE_END_DATE IS NOT NULL AND p_party_rec.ACTIVE_END_DATE < SYSDATE THEN
2622: BEGIN
2623: SELECT 'T'
2624: INTO l_inst_just_expired
2625: FROM CSI_ITEM_INSTANCES_H
2626: WHERE INSTANCE_ID = p_party_rec.INSTANCE_ID
2627: AND TRANSACTION_ID = p_txn_rec.TRANSACTION_ID
2628: AND OLD_ACTIVE_END_DATE IS NULL
2629: AND NEW_ACTIVE_END_DATE < SYSDATE