APPS.CSM_IB_TXN_SUB_TYPES_EVENT_PKG dependencies on CSI_INSTANCE_STATUSES

Line 53: csi_instance_statuses cis , cs_transaction_types_b ttb

49: FROM csm_ib_txn_types_acc acc
50: WHERE NOT EXISTS
51: (SELECT cit.sub_type_id
52: FROM csi_ib_txn_types cit , csi_source_ib_types cst , csi_txn_types ctt ,
53: csi_instance_statuses cis , cs_transaction_types_b ttb
54: WHERE acc.sub_type_id = cit.sub_type_id
55: AND cit.cs_transaction_type_id = ttb.transaction_type_id(+)
56: AND ctt.source_application_id = 513
57: AND ctt.source_transaction_type = 'FIELD_SERVICE_REPORT'

Line 156: csi_instance_statuses cis ,

152: FROM csm_ib_txn_types_acc acc ,
153: csi_ib_txn_types cit,
154: csi_source_ib_types cst ,
155: csi_txn_types ctt ,
156: csi_instance_statuses cis ,
157: cs_transaction_types_b ttb
158: WHERE acc.sub_type_id = cit.sub_type_id
159: AND cit.cs_transaction_type_id = ttb.transaction_type_id(+)
160: AND ctt.source_application_id = 513

Line 239: csi_instance_statuses cis , cs_transaction_types_b ttb

235: /****** INSERTS **********/
236: --generate sql for inserts
237: l_dsql := 'SELECT cit.sub_type_id
238: FROM csi_ib_txn_types cit , csi_source_ib_types cst , csi_txn_types ctt ,
239: csi_instance_statuses cis , cs_transaction_types_b ttb
240: WHERE cit.cs_transaction_type_id = ttb.transaction_type_id(+)
241: AND ctt.source_application_id = 513
242: AND ctt.source_transaction_type = ''FIELD_SERVICE_REPORT''
243: AND cst.sub_type_id = cit.sub_type_id