APPS.XNP_CVU_PKG dependencies on XNP_SV_STATUS_TYPES_B

Line 390: FROM xnp_sv_status_types_b

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
392: AND active_flag = 'Y');
393:
394: EXCEPTION when no_data_found then

Line 450: FROM xnp_sv_status_types_b sst, fnd_lookup_values flv

446: 'INQUIRY', decode (count(*), 0, gc_WARNING,gc_OK),
447: decode(count(*), 0, gc_ERROR,gc_OK)) result_type
448: FROM
449: (SELECT flv.lookup_code pi, sst.status_type_code stc
450: FROM xnp_sv_status_types_b sst, fnd_lookup_values flv
451: WHERE flv.lookup_code = sst.phase_indicator (+)
452: AND flv.lookup_type = 'XNP_PHASE_INDICATOR'
453: AND flv.enabled_flag = 'Y'
454: AND sst.active_flag = 'Y')