APPS.CSM_IB_TXN_SUB_TYPES_EVENT_PKG dependencies on CSI_TXN_TYPES

Line 52: FROM csi_ib_txn_types cit , csi_source_ib_types cst , csi_txn_types ctt ,

48: SELECT acc.access_id
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

Line 155: csi_txn_types ctt ,

151: l_dsql := 'SELECT acc.access_id
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(+)

Line 238: FROM csi_ib_txn_types cit , csi_source_ib_types cst , csi_txn_types ctt ,

234:
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''