DBA Data[Home] [Help]

APPS.XNP_CVU_PKG dependencies on XDP_FA_FULFILLMENT_PROC

Line 553: FROM xdp_fa_fulfillment_proc fap

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

Line 561: FROM xdp_fa_fulfillment_proc fap

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

Line 566: FROM xdp_fa_fulfillment_proc fap ,

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