DBA Data[Home] [Help]

APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_TRANSACTIONS

Line 665: csi_transactions t

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);
669:

Line 685: csi_transactions t

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);
689:

Line 707: csi_transactions t

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);
711:

Line 1308: csi_transactions t

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);
1312: