DBA Data[Home] [Help]

APPS.AHL_VWP_UNPLAN_TASKS_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 584: FROM AHL_VISIT_TASKS_B AVTB, AHL_MR_HEADERS_APP_V AMHV

580:
581: -- To find any visit task exists for the retrieve Serial Number and MR_ID and other info
582: CURSOR c_MR_Visit (x_id IN NUMBER, x_mr_id IN NUMBER, x_serial_id in NUMBER) IS
583: SELECT AMHV.TITLE
584: FROM AHL_VISIT_TASKS_B AVTB, AHL_MR_HEADERS_APP_V AMHV
585: WHERE AVTB.MR_ID = AMHV.MR_HEADER_ID
586: AND AVTB.MR_Id in (select mr_header_id
587: from ahl_mr_headers_b
588: where title in