APPS.CSM_DEBRIEF_PARTS_PKG dependencies on CS_TRANSACTION_TYPES_B

Line 71: cs_transaction_types_b ttb,

67: SELECT tbt.txn_billing_type_id
68: FROM
69: csm_txn_billing_types_acc acc,
70: cs_txn_billing_types tbt,
71: cs_transaction_types_b ttb,
72: cs_business_processes bpr, cs_bus_process_txns bpt, CS_BILLING_TYPE_CATEGORIES cbtc
73: WHERE acc.txn_billing_type_id = tbt.txn_billing_type_id
74: AND acc.business_process_id = bpt.business_process_id
75: AND tbt.transaction_type_id = ttb.transaction_type_id

Line 88: FROM CS_TRANSACTION_TYPES_B ttb

84:
85: CURSOR c_material_transaction ( b_transaction_type_id NUMBER )
86: IS
87: SELECT ttb.line_order_category_code
88: FROM CS_TRANSACTION_TYPES_B ttb
89: WHERE ttb.transaction_type_id = b_transaction_type_id;
90:
91:
92: -- Cursor to check if the Assignment Status is either of the