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_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_IP_ACCOUNTS_H

Line 706: FROM csi_ip_accounts_h s,

702: FETCH C2 into l_account_temp;
703: IF C2%FOUND then
704: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
705: INTO l_transaction_date
706: FROM csi_ip_accounts_h s,
707: csi_transactions t
708: WHERE s.ip_account_id =l_account_temp
709: AND s.transaction_id=t.transaction_id
710: AND t.transaction_id <> nvl(p_txn_id, -99999);

Line 1307: FROM csi_ip_accounts_h s,

1303:
1304: IF p_end_date < sysdate THEN
1305: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
1306: INTO l_transaction_date
1307: FROM csi_ip_accounts_h s,
1308: csi_transactions t
1309: WHERE s.ip_account_id=p_ip_account_id
1310: AND s.transaction_id=t.transaction_id
1311: AND t.transaction_id <> nvl(p_txn_id, -99999);

Line 1372: SELECT CSI_IP_ACCOUNTS_H_S.nextval

1368: FUNCTION gen_ip_account_hist_id
1369: RETURN NUMBER IS
1370: l_ip_account_hist_id NUMBER;
1371: BEGIN
1372: SELECT CSI_IP_ACCOUNTS_H_S.nextval
1373: INTO l_ip_account_hist_id
1374: FROM sys.dual;
1375: RETURN l_ip_account_hist_id ;
1376: END gen_ip_account_hist_id;