DBA Data[Home] [Help]

APPS.XNP_CVU_PKG dependencies on XNP_MSG_TYPES_VL

Line 2831: FROM xnp_msg_types_vl mt

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