APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on AHL_VISIT_TASKS_VL

Line 3744: SELECT VISIT_TASK_NAME,TASK_TYPE_CODE FROM ahl_visit_tasks_vl WHERE

3740: SELECT VISIT_NAME, VISIT_NUMBER FROM ahl_visits_vl WHERE
3741: VISIT_ID = p_visit_id;
3742:
3743: CURSOR l_get_task_name_csr(p_task_id IN NUMBER) IS
3744: SELECT VISIT_TASK_NAME,TASK_TYPE_CODE FROM ahl_visit_tasks_vl WHERE
3745: VISIT_TASK_ID = p_task_id;
3746: --
3747: CURSOR l_get_dept_cur (c_dept_name IN VARCHAR2,
3748: c_org_name IN VARCHAR2)