APPS.XNP_CVU_PKG dependencies on XNP_NUMBER_RANGES

Line 910: FROM xnp_number_ranges

906: v_first_time BOOLEAN := TRUE;
907:
908: CURSOR c_geo_num_range IS
909: SELECT number_range_id, starting_number, ending_number
910: FROM xnp_number_ranges
911: WHERE geo_indicator = gc_GEO
912: AND geo_area_id IS NULL;
913:
914: CURSOR c_nogeo_num_range IS

Line 916: FROM xnp_number_ranges

912: AND geo_area_id IS NULL;
913:
914: CURSOR c_nogeo_num_range IS
915: SELECT number_range_id, starting_number,ending_number
916: FROM xnp_number_ranges
917: WHERE geo_indicator <> gc_GEO
918: AND geo_area_id IS NOT NULL;
919:
920: BEGIN

Line 979: FROM xnp_number_ranges

975: CURSOR c_num_range IS
976: SELECT number_range_id, starting_number, ending_number,
977: to_char(effective_date, gc_DATE_FORMAT) effective_date,
978: nvl(active_flag, gc_NULL) active_flag
979: FROM xnp_number_ranges
980: WHERE effective_date > SYSDATE
981: OR nvl(active_flag,'N') <> 'Y';
982:
983:

Line 1026: FROM xnp_number_ranges

1022:
1023: CURSOR c_not_pooled_num_ranges IS
1024: SELECT number_range_id, starting_number, ending_number,
1025: assigned_sp_id, owning_sp_id, pooled_flag
1026: FROM xnp_number_ranges
1027: WHERE pooled_flag = 'N'
1028: AND assigned_sp_id <> owning_sp_id;
1029:
1030: CURSOR c_pooled_num_ranges IS

Line 1032: FROM xnp_number_ranges

1028: AND assigned_sp_id <> owning_sp_id;
1029:
1030: CURSOR c_pooled_num_ranges IS
1031: SELECT number_range_id, starting_number, ending_number
1032: FROM xnp_number_ranges
1033: WHERE pooled_flag = 'Y'
1034: AND assigned_sp_id IS NULL;
1035:
1036: BEGIN

Line 1095: FROM xnp_number_ranges

1091:
1092: CURSOR c_number_ranges IS
1093: SELECT number_range_id,
1094: starting_number, ending_number, ported_indicator
1095: FROM xnp_number_ranges
1096: WHERE ported_indicator NOT IN ('NON_PORTED', 'NON_PORTABLE');
1097:
1098: BEGIN
1099: v_first_time := TRUE;

Line 1140: FROM xnp_served_num_ranges snr, xnp_number_ranges nr

1136:
1137:
1138: CURSOR c_served_num_ranges_err IS
1139: SELECT snr.number_range_id, nr.starting_number, nr.ending_number
1140: FROM xnp_served_num_ranges snr, xnp_number_ranges nr
1141: WHERE NOT EXISTS
1142: (SELECT 'X'
1143: FROM xdp_fes fes
1144: WHERE fes.fe_id = snr.fe_id

Line 1191: FROM xnp_number_ranges;

1187:
1188: CURSOR c_number_ranges IS
1189: SELECT number_range_id,
1190: starting_number, ending_number
1191: FROM xnp_number_ranges;
1192:
1193:
1194: BEGIN
1195: v_first_time := TRUE;