DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_UPDATE_PKG dependencies on CSI_TXN_TYPES

Line 340: csi_txn_types ctt

336: ctst.transaction_type_id transaction_type_id_csi
337: from cs_transaction_types_vl cttv,
338: cs_txn_billing_types ctbt,
339: csi_txn_sub_types ctst,
340: csi_txn_types ctt
341: where cttv.transaction_type_id = ctbt.transaction_type_id
342: and ctbt.txn_billing_type_id = p_txn_billing_type_id
343: and ctst.cs_transaction_type_id = cttv.transaction_type_id
344: and ctt.source_application_id=513

Line 364: csi_txn_types ctt,

360: ctst.transaction_type_id transaction_type_id_csi
361: from cs_transaction_types_vl cttv,
362: cs_txn_billing_types ctbt,
363: csi_txn_sub_types ctst,
364: csi_txn_types ctt,
365: mtl_system_items_b_kfv msibk,
366: cs_billing_type_categories cbtc
367: where cttv.transaction_type_id = p_transaction_type_id
368: and cttv.transaction_type_id = ctbt.transaction_type_id