DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PVT dependencies on CSI_T_PARTY_ACCOUNTS

Line 1693: ,csi_t_party_accounts cia

1689: pc_txn_party_detail_id IN NUMBER) IS
1690: SELECT cia.account_id
1691: FROM csi_t_txn_line_details cil
1692: ,csi_t_party_details cid
1693: ,csi_t_party_accounts cia
1694: WHERE cil.transaction_line_id = pc_txn_line_id
1695: AND cil.instance_id IS NOT NULL
1696: AND cid.txn_line_detail_id = cil.txn_line_detail_id
1697: AND cid.relationship_type_code = 'OWNER'

Line 1847: FROM csi_t_party_accounts ctpa

1843: CURSOR acct_csr (pc_txn_party_detail_id IN NUMBER) IS
1844: SELECT ctpa.txn_account_detail_id,
1845: ctpa.txn_party_detail_id,
1846: ctpa.account_id
1847: FROM csi_t_party_accounts ctpa
1848: WHERE ctpa.txn_party_detail_id = pc_txn_party_detail_id;
1849:
1850: acct_rec acct_csr%rowtype;
1851: