APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VWP_STAGES_B

Line 7908: ahl_vwp_stages_b STG

7904: IS
7905: -- To find out the maximum task number value in the visit
7906: CURSOR c_is_old_visit IS
7907: select sum(1) from AHL_VISITS_B VST,
7908: ahl_vwp_stages_b STG
7909: WHERE VST.visit_id = STG.VISIT_ID AND VST.VISIT_ID = p_visit_id
7910: AND nvl2(STG.stage_status_code,'Y','N') = 'N';
7911:
7912: l_is_old_visit VARCHAR2(1) := 'N';