2827: -- MESSAGE_TYPE
2828:
2829: SELECT count(*)
2830: INTO v_cnt 2831: FROM xnp_msg_types_vl mt 2832: WHERE NOT EXISTS
2833: (SELECT 1
2834: FROM wf_lookups wl
2835: WHERE substr(wl.lookup_code,1,29) = substr(mt.msg_code,1, 29)
Line 2849: FROM xnp_msg_types_vl mt
2845: -- TIMER_NAMES
2846:
2847: SELECT count(*)
2848: INTO v_cnt 2849: FROM xnp_msg_types_vl mt 2850: WHERE msg_type = 'TIMER'
2851: AND NOT EXISTS
2852: (SELECT 1
2853: FROM wf_lookups wl