APPS.XNP_CVU_PKG dependencies on DUAL

Line 387: FROM dual

383: VAL => v_default_porting_status);
384:
385: SELECT 1
386: INTO v_invalid_status
387: FROM dual
388: WHERE EXISTS
389: (SELECT 'X'
390: FROM xnp_sv_status_types_b
391: WHERE status_type_code = v_default_porting_status

Line 419: FROM dual

415: VAL => v_local_sp_name);
416:
417: SELECT 1
418: INTO v_invalid_sp_name
419: FROM dual
420: WHERE EXISTS
421: (SELECT 'X'
422: FROM xnp_service_providers
423: WHERE code = v_local_sp_name

Line 1688: FROM dual

1684:
1685: BEGIN
1686: SELECT 'XNP_CVU_WF_LHS_NOT_VALID_ELEM'
1687: INTO v_lhs_msg
1688: FROM dual
1689: WHERE NOT EXISTS
1690: (SELECT 1
1691: FROM xnp_msg_elements me
1692: WHERE me.name = p_LHS

Line 1708: FROM dual

1704:
1705: BEGIN
1706: SELECT 'XNP_CVU_WF_RHS_NOTVALID_PARAM'
1707: INTO v_rhs_msg
1708: FROM dual
1709: WHERE NOT EXISTS
1710: (SELECT 1
1711: FROM fnd_lookups flk
1712: WHERE flk.lookup_code = p_RHS

Line 1721: FROM dual

1717: -- 07/19/2001
1718: /*
1719: SELECT 'XNP_CVU_WF_RHS_NOTVALID_PARAM'
1720: INTO v_rhs_msg
1721: FROM dual
1722: WHERE NOT EXISTS
1723: (SELECT 1
1724: FROM xdp_parameter_pool pol
1725: WHERE pol.parameter_name = p_RHS);

Line 1786: FROM dual

1782:
1783: BEGIN
1784: SELECT 'XNP_CVU_WF_NOT_VALID_EVT_TYPE'
1785: INTO v_no_such_evt
1786: FROM dual
1787: WHERE NOT EXISTS
1788: (SELECT 1
1789: FROM xnp_msg_types_b me
1790: WHERE me.msg_code = p_message_code);