APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_I_PARTIES_H

Line 664: FROM csi_i_parties_h s,

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

Line 684: FROM csi_i_parties_h s,

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

Line 802: SELECT CSI_I_PARTIES_H_S.nextval

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