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_I_PARTIES_H

Line 666: FROM csi_i_parties_h s,

662: BEGIN
663:
664: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
665: INTO l_transaction_date
666: FROM csi_i_parties_h s,
667: csi_transactions t
668: WHERE s.instance_party_id=p_instance_party_id
669: AND s.transaction_id=t.transaction_id
670: AND t.transaction_id <>nvl(p_txn_id, -99999);

Line 686: FROM csi_i_parties_h s,

682: FETCH C1 into l_contact_temp;
683: IF C1%FOUND then
684: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
685: INTO l_transaction_date
686: FROM csi_i_parties_h s,
687: csi_transactions t
688: WHERE s.instance_party_id=l_contact_temp
689: AND s.transaction_id=t.transaction_id
690: AND t.transaction_id <> nvl(p_txn_id, -99999);

Line 804: SELECT CSI_I_PARTIES_H_S.nextval

800: FUNCTION gen_inst_party_hist_id
801: RETURN NUMBER IS
802: l_inst_party_his_id NUMBER;
803: BEGIN
804: SELECT CSI_I_PARTIES_H_S.nextval
805: INTO l_inst_party_his_id
806: FROM sys.dual;
807: RETURN l_inst_party_his_id ;
808: END gen_inst_party_hist_id;