APPS.XNP_CVU_PKG dependencies on XDP_FE_GENERIC_CONFIG

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 718: FROM xdp_fe_generic_config fgc

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
720: AND SYSDATE BETWEEN fgc.start_date
721: AND nvl(fgc.end_date, gc_max_date)
722: );

Line 816: FROM xdp_fe_generic_config fgc

812: CURSOR c_no_proc IS
813: SELECT fgc.fe_id,
814: nvl(fgc.sw_start_proc, gc_NULL) sw_start_proc,
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