APPS.CSI_ML_INTERFACE_TXN_PVT dependencies on CSI_I_ASSET_INTERFACE

Line 234: FROM csi_i_asset_interface cia

230: WHERE ci.inst_interface_id = p_inst_interface_id;
231:
232: CURSOR iasset_iface_cur(p_inst_interface_id IN NUMBER) IS
233: SELECT cia.*
234: FROM csi_i_asset_interface cia
235: WHERE cia.inst_interface_id = p_inst_interface_id; --bnarayan added for open interfaces R12
236:
237:
238: /*CURSOR irel_det_cur(p_txn_ident IN VARCHAR2,

Line 506: ,csi_i_asset_interface ciai

502: 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))
503: AND cii.process_status = 'R'
504: AND exists ( SELECT 1
505: FROM csi_i_party_interface cipi
506: ,csi_i_asset_interface ciai
507: WHERE cipi.inst_interface_id = ciai.inst_interface_id
508: AND cipi.inst_interface_id = cii.inst_interface_id
509: AND nvl(cipi.party_id,0) <> g_int_party
510: AND cipi.party_relationship_type_code = 'OWNER'

Line 532: FROM csi_i_asset_interface ciai

528: AND cii.source_system_name = p_source_system_name
529: 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))
530: AND cii.process_status = 'R'
531: AND exists (SELECT 1
532: FROM csi_i_asset_interface ciai
533: WHERE cii.inst_interface_id = ciai.inst_interface_id
534: AND ciai.fa_asset_id IS NULL
535: AND ciai.fa_asset_number IS NULL
536: );

Line 565: FROM csi_i_asset_interface ciai

561: AND nvl(cipi.party_id,0) = g_int_party
562: AND cipi.party_relationship_type_code = 'OWNER'
563: )
564: AND not exists (SELECT 1
565: FROM csi_i_asset_interface ciai
566: WHERE cii.inst_interface_id = ciai.inst_interface_id
567: ));
568:
569: IF SQL%FOUND THEN