APPS.XNP_CVU_PKG dependencies on XDP_FES

Line 567: xdp_fes fes,

563:
564: AND NOT EXISTS
565: (SELECT 1
566: FROM xdp_fa_fulfillment_proc fap ,
567: xdp_fes fes,
568: xdp_fe_sw_gen_lookup fgl
569: WHERE fap.fulfillment_action_id
570: = fa.fulfillment_action_id
571: AND fap.fe_sw_gen_lookup_id

Line 639: FROM xdp_fes

635: SELECT fe_id id, fulfillment_element_name name,
636: to_char(invalid_date, gc_DATE_FORMAT) valid_date,
637: DECODE(invalid_date, null, gc_NULL,
638: to_char(invalid_date, gc_DATE_FORMAT)) invalid_date
639: FROM xdp_fes
640: WHERE invalid_date < SYSDATE;
641:
642: CURSOR c_date_window IS
643: SELECT fe.fe_id id, fulfillment_element_name name,

Line 647: FROM xdp_fes fe, xdp_fe_generic_config fgc

643: SELECT fe.fe_id id, fulfillment_element_name name,
644: to_char(valid_date, gc_DATE_FORMAT) valid_date,
645: DECODE(invalid_date, null, gc_NULL,
646: to_char(invalid_date, gc_DATE_FORMAT)) invalid_date
647: FROM xdp_fes fe, xdp_fe_generic_config fgc
648: WHERE fe.fe_id = fgc.fe_id
649: AND NOT
650: (fgc.start_date BETWEEN
651: fe.valid_date and nvl(fe.invalid_date, gc_max_date)

Line 715: FROM xdp_fes fe

711: v_first_time BOOLEAN := TRUE;
712:
713: CURSOR c_no_gen_config IS
714: SELECT fe.fe_id id , fe.fulfillment_element_name name
715: FROM xdp_fes fe
716: WHERE NOT EXISTS
717: (SELECT 1
718: FROM xdp_fe_generic_config fgc
719: WHERE fe.fe_id = fgc.fe_id

Line 726: FROM xdp_fes fe

722: );
723:
724: CURSOR c_no_adapter IS
725: SELECT fe.fe_id id, fe.fulfillment_element_name name
726: FROM xdp_fes fe
727: WHERE NOT EXISTS
728: (SELECT 1
729: FROM xdp_adapter_reg ar
730: WHERE fe.fe_id = ar.fe_id);

Line 819: FROM xdp_fes fes

815: nvl(fgc.sw_exit_proc, gc_NULL) sw_exit_proc
816: FROM xdp_fe_generic_config fgc
817: WHERE EXISTS
818: (SELECT 1
819: FROM xdp_fes fes
820: WHERE fes.fe_id = fgc.fe_id
821: AND fetype_id IN (SELECT fetype_id
822: FROM xdp_fe_types
823: WHERE fulfillment_element_type

Line 1143: FROM xdp_fes fes

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
1145: AND SYSDATE
1146: BETWEEN fes.valid_date and NVL(fes.invalid_date,SYSDATE)
1147: )

Line 2249: FROM xdp_fes

2245: IF v_text_value IS NOT NULL
2246: THEN
2247: SELECT count(*)
2248: INTO v_count
2249: FROM xdp_fes
2250: WHERE fulfillment_element_name = v_text_value;
2251:
2252: IF v_count = 0 THEN
2253: p_text2 := 'XNP_CVU_EXECUTE_FA_FE_NAME';

Line 2795: FROM xdp_fes_vl fe

2791: -- FE_NAME
2792:
2793: SELECT count(*)
2794: INTO v_cnt
2795: FROM xdp_fes_vl fe
2796: WHERE NOT EXISTS
2797: (SELECT 1
2798: FROM wf_lookups wl
2799: WHERE substr(wl.lookup_code,1,29) = substr(fe.fulfillment_element_name,1, 29)