APPS.XNP_CVU_PKG dependencies on XDP_FULFILL_ACTIONS

Line 550: FROM xdp_fulfill_actions fa

546: v_first_time BOOLEAN := TRUE;
547:
548: CURSOR c_no_fp IS
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);

Line 558: FROM xdp_fulfill_actions fa

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
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)

Line 2221: FROM xdp_fulfill_actions

2217: p_text1 := 'XNP_CVU_EXECUTE_FA_FA_NAME';
2218: ELSE
2219: SELECT count(*)
2220: INTO v_count
2221: FROM xdp_fulfill_actions
2222: WHERE fulfillment_action = v_text_value;
2223:
2224: IF v_count = 0 THEN
2225: p_text1 := 'XNP_CVU_EXECUTE_FA_FA_NAME';

Line 2813: FROM xdp_fulfill_actions_vl fa

2809: -- FA_NAME
2810:
2811: SELECT count(*)
2812: INTO v_cnt
2813: FROM xdp_fulfill_actions_vl fa
2814: WHERE NOT EXISTS
2815: (SELECT 1
2816: FROM wf_lookups wl
2817: WHERE substr(wl.lookup_code,1,29) = substr(fa.fulfillment_action,1, 29)