APPS.CSI_T_TXN_LINE_DTLS_PVT dependencies on CSI_I_PARTIES

Line 970: l_instance_party_id csi_i_parties.instance_party_id%TYPE;

966: SELECT *
967: FROM csi_t_txn_line_details
968: WHERE txn_line_detail_id = p_line_dtl_id;
969:
970: l_instance_party_id csi_i_parties.instance_party_id%TYPE;
971: l_pty_ids_tbl csi_t_datastructures_grp.txn_party_ids_tbl;
972: l_pty_ind binary_integer;
973: l_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;
974: l_x_pty_acct_ids_tbl csi_t_datastructures_grp.txn_pty_acct_ids_tbl;

Line 1685: FROM csi_i_parties

1681: IF l_pty_cur_rec.Contact_party_id is NULL THEN
1682:
1683: SELECT instance_party_id
1684: INTO l_instance_party_id
1685: FROM csi_i_parties
1686: WHERE instance_id = l_td_rec.instance_id -- new instance
1687: AND party_id = l_pty_cur_rec.party_source_id -- old party
1688: AND party_source_table = l_pty_cur_rec.party_source_table
1689: AND relationship_type_code = l_pty_cur_rec.relationship_type_code

Line 1701: csi_i_parties csiip,

1697:
1698: SELECT csiip.instance_party_id
1699: INTO l_instance_party_id
1700: FROM
1701: csi_i_parties csiip,
1702: csi_i_parties csiipc,
1703: csi_t_party_details csitpd,
1704: csi_t_party_details csitpdc
1705: WHERE csitpdc.party_SOURCE_id = l_pty_cur_rec.party_source_id

Line 1702: csi_i_parties csiipc,

1698: SELECT csiip.instance_party_id
1699: INTO l_instance_party_id
1700: FROM
1701: csi_i_parties csiip,
1702: csi_i_parties csiipc,
1703: csi_t_party_details csitpd,
1704: csi_t_party_details csitpdc
1705: WHERE csitpdc.party_SOURCE_id = l_pty_cur_rec.party_source_id
1706: AND csiipc.instance_id=l_td_rec.instance_id

Line 1735: FROM csi_i_parties

1731: IF l_pty_cur_rec.relationship_type_code = 'OWNER' THEN
1732:
1733: SELECT instance_party_id
1734: INTO l_instance_party_id
1735: FROM csi_i_parties
1736: WHERE instance_id = l_td_rec.instance_id
1737: AND relationship_type_code = 'OWNER';
1738:
1739: ELSE