APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on AHL_VISIT_TASKS_V

Line 967: FROM ahl_visit_tasks_v

963: --yazhou 12-May-2006 ends
964:
965: CURSOR Order_Number_Cur(c_visit_task_id IN NUMBER) IS
966: SELECT visit_number||visit_task_number Order_Number
967: FROM ahl_visit_tasks_v
968: WHERE visit_task_id = c_visit_task_id;
969:
970: CURSOR Instance_Id_Cur IS
971: SELECT instance_id