APPS.CSI_MASS_EDIT_PVT dependencies on CSI_T_PARTY_DETAILS

Line 1682: ,csi_t_party_details cid

1678: ,cil.txn_line_detail_id txn_line_detail_id
1679: ,cil.instance_id instance_id
1680: ,cid.txn_party_detail_id txn_party_detail_id
1681: FROM csi_t_txn_line_details cil
1682: ,csi_t_party_details cid
1683: WHERE cil.transaction_line_id = pc_txn_line_id
1684: AND cil.instance_id IS NOT NULL
1685: AND cid.txn_line_detail_id = cil.txn_line_detail_id
1686: AND cid.relationship_type_code = 'OWNER';

Line 1692: ,csi_t_party_details cid

1688: CURSOR account_csr (pc_txn_line_id IN NUMBER,
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

Line 1838: FROM csi_t_party_details ctpd

1834: SELECT ctpd.txn_party_detail_id,
1835: ctpd.txn_line_detail_id,
1836: ctpd.party_source_id,
1837: ctpd.party_source_table
1838: FROM csi_t_party_details ctpd
1839: WHERE ctpd.txn_line_detail_id = pc_txn_line_id;
1840:
1841: party_rec party_csr%rowtype;
1842:

Line 2121: ,csi_t_party_details cid

2117: CURSOR party_csr (pc_txn_line_id IN NUMBER) IS
2118: SELECT cid.active_start_date active_start_date
2119: ,cid.txn_line_detail_id txn_line_detail_id
2120: FROM csi_t_txn_line_details cil
2121: ,csi_t_party_details cid
2122: WHERE cil.transaction_line_id = pc_txn_line_id
2123: AND cil.instance_id IS NULL
2124: AND cid.txn_line_detail_id = cil.txn_line_detail_id
2125: AND cid.relationship_type_code = 'OWNER';