APPS.CSI_ML_CREATE_PVT dependencies on CSI_I_PARTY_INTERFACE

Line 76: FROM csi_i_party_interface cpi

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

Line 149: FROM csi_i_party_interface cipi

145: AND cii.process_status = 'X'
146: AND cii.source_system_name = p_source_system_name
147: 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))
148: AND exists ( SELECT 1
149: FROM csi_i_party_interface cipi
150: ,csi_i_asset_interface ciai
151: WHERE cipi.inst_interface_id = ciai.inst_interface_id
152: AND cipi.inst_interface_id = cii.inst_interface_id
153: AND nvl(cipi.party_id,0) <> l_int_party

Line 197: FROM csi_i_party_interface cipi

193: AND cii.source_system_name = p_source_system_name
194: 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))
195: AND cii.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
196: AND (exists (SELECT 1
197: FROM csi_i_party_interface cipi
198: WHERE cipi.inst_interface_id = cii.inst_interface_id
199: AND nvl(cipi.party_id,0) = l_int_party
200: AND cipi.party_relationship_type_code = 'OWNER'
201: )