APPS.AMS_CPYUTILITY_PVT dependencies on AMS_CAMPAIGNS_VL

Line 457: FROM AMS_CAMPAIGNS_VL

453: l_number := 0;
454: IF p_arc_act_code = 'CAMP' THEN
455: SELECT actual_exec_end_date ,actual_exec_start_date
456: INTO end_date,start_date
457: FROM AMS_CAMPAIGNS_VL
458: WHERE campaign_id = p_activity_id;
459:
460: l_number := (end_date - start_date);
461: