APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_VISITS_B_S
Line 1845: SELECT Ahl_Visits_B_S.NEXTVAL INTO l_visit_id
1841: AHL_DEBUG_PUB.debug( 'visit_type_code'||l_visit_detail_rec.visit_type_code);
1842: AHL_DEBUG_PUB.debug( 'inventory_id'||l_visit_detail_rec.inventory_item_id);
1843: END IF;
1844: --Get visit id 1845: SELECT Ahl_Visits_B_S.NEXTVAL INTO l_visit_id 1846: FROM dual;
1847: --Get visit number
1848: SELECT MAX(visit_number) INTO l_visit_number
1849: FROM Ahl_Visits_B;