APPS.CSM_IB_TXN_SUB_TYPES_EVENT_PKG dependencies on CS_TRANSACTION_TYPES_B

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 98: CURSOR l_txn_types_tl_cur (p_transaction_type_id IN cs_transaction_types_b.transaction_type_id%TYPE)

94: );
95:
96: l_temp_date date;
97:
98: CURSOR l_txn_types_tl_cur (p_transaction_type_id IN cs_transaction_types_b.transaction_type_id%TYPE)
99: IS
100: SELECT tt_tl.LANGUAGE
101: FROM cs_transaction_types_tl tt_tl
102: WHERE tt_tl.transaction_type_id = p_transaction_type_id;

Line 157: cs_transaction_types_b ttb

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
161: AND ctt.source_transaction_type = ''FIELD_SERVICE_REPORT''

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