APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on AHL_VISITS_VL

Line 3740: SELECT VISIT_NAME, VISIT_NUMBER FROM ahl_visits_vl WHERE

3736: x_task_req_tbl OUT NOCOPY Task_Requirement_Tbl_Type
3737: ) IS
3738:
3739: CURSOR l_get_visit_name_csr(p_visit_id IN NUMBER) IS
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