DBA Data[Home] [Help]

APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_TXN_SUB_TYPES

Line 8765: FROM csi_txn_sub_types

8761: BEGIN
8762:
8763: SELECT sub_type_id
8764: INTO l_dflt_sub_type_id
8765: FROM csi_txn_sub_types
8766: WHERE transaction_type_id = 53
8767: AND default_flag = 'Y';
8768: --
8769: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

Line 8806: FROM csi_txn_sub_types

8802: END IF;
8803:
8804: SELECT nvl(src_change_owner, 'N')
8805: INTO l_change_owner_flag
8806: FROM csi_txn_sub_types
8807: WHERE transaction_type_id = 53
8808: AND sub_type_id = l_sub_type_id;
8809:
8810:

Line 15446: FROM csi_txn_sub_types

15442: SELECT sub_type_id ,
15443: src_change_owner
15444: INTO l_sub_type_id,
15445: l_change_owner
15446: FROM csi_txn_sub_types
15447: WHERE transaction_type_id = 53
15448: AND default_flag = 'Y';
15449:
15450: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN