APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_VISITS_B

Line 584: SELECT status_code FROM AHL_VISITS_B

580:
581: l_planned_order_flag VARCHAR2(1);
582:
583: CURSOR c_check_visit_status(C_VISIT_ID NUMBER) IS
584: SELECT status_code FROM AHL_VISITS_B
585: WHERE VISIT_ID = C_VISIT_ID
586: AND STATUS_CODE IN ('PLANNING', 'PARTIALLY RELEASED', 'RELEASED' );
587:
588: -- Commented based on review comments