APPS.CSI_ML_CREATE_PVT dependencies on CSI_I_PARTY_INTERFACE

Line 78: FROM csi_i_party_interface cpi

74: r_inst c_inst%rowtype;
75:
76: CURSOR c_prty (pc_interface_id in NUMBER) IS
77: SELECT cpi.*
78: FROM csi_i_party_interface cpi
79: WHERE cpi.inst_interface_id = pc_interface_id;
80:
81: r_prty c_prty%rowtype;
82:

Line 157: FROM csi_i_party_interface cipi

153: AND cii.process_status = 'X'
154: AND cii.source_system_name = p_source_system_name
155: AND trunc(cii.source_transaction_date) BETWEEN nvl(l_txn_from_date,trunc(cii.source_transaction_date)) AND nvl(l_txn_to_date,trunc(cii.source_transaction_date))
156: AND exists ( SELECT 1
157: FROM csi_i_party_interface cipi
158: ,csi_i_asset_interface ciai
159: WHERE cipi.inst_interface_id = ciai.inst_interface_id
160: AND cipi.inst_interface_id = cii.inst_interface_id
161: AND nvl(cipi.party_id,0) <> l_int_party

Line 207: FROM csi_i_party_interface cipi

203: AND cii.source_system_name = p_source_system_name
204: AND trunc(cii.source_transaction_date) BETWEEN nvl(l_txn_from_date,trunc(cii.source_transaction_date)) AND nvl(l_txn_to_date,trunc(cii.source_transaction_date))
205: AND cii.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
206: AND (exists (SELECT 1
207: FROM csi_i_party_interface cipi
208: WHERE cipi.inst_interface_id = cii.inst_interface_id
209: AND nvl(cipi.party_id,0) = l_int_party
210: AND cipi.party_relationship_type_code = 'OWNER'
211: )