549: SELECT fulfillment_action_id id, fulfillment_action name
550: FROM xdp_fulfill_actions fa
551: WHERE NOT EXISTS
552: (SELECT 1
553: FROM xdp_fa_fulfillment_proc fap
554: WHERE fap.fulfillment_action_id = fa.fulfillment_action_id);
555:
556: CURSOR c_no_fe IS
557: SELECT fulfillment_action_id id, fulfillment_action name
557: SELECT fulfillment_action_id id, fulfillment_action name
558: FROM xdp_fulfill_actions fa
559: WHERE EXISTS
560: (SELECT 1
561: FROM xdp_fa_fulfillment_proc fap
562: WHERE fap.fulfillment_action_id = fa.fulfillment_action_id)
563:
564: AND NOT EXISTS
565: (SELECT 1
562: WHERE fap.fulfillment_action_id = fa.fulfillment_action_id)
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