APPS.AHL_LTP_REQST_MATRL_PVT dependencies on DUAL

Line 434: SELECT ahl_schedule_materials_s.nextval INTO l_schedule_material_id FROM DUAL;

430: 'Request for Create Planned Material for Visit Id: ' || p_visit_id);
431: END IF;
432:
433: --Get the sequence number
434: SELECT ahl_schedule_materials_s.nextval INTO l_schedule_material_id FROM DUAL;
435: --Check for record exists
436: -- Surrkuma on 28-Jul-2011 for handling control position based material requirements
437: OPEN check_matrl_cur(p_visit_id,p_visit_task_id,p_rt_oper_material_id,p_position_key);
438: FETCH check_matrl_cur INTO l_dummy;