DBA Data[Home] [Help]

APPS.AHL_LTP_SIMUL_PLAN_PVT dependencies on AHL_VISITS_B_S

Line 1861: SELECT Ahl_Visits_B_S.NEXTVAL INTO l_visit_id

1857: AHL_DEBUG_PUB.debug( 'visit_type_code'||l_visit_detail_rec.visit_type_code);
1858: AHL_DEBUG_PUB.debug( 'inventory_id'||l_visit_detail_rec.inventory_item_id);
1859: END IF;
1860: --Get visit id
1861: SELECT Ahl_Visits_B_S.NEXTVAL INTO l_visit_id
1862: FROM dual;
1863: --Get visit number
1864: SELECT MAX(visit_number) INTO l_visit_number
1865: FROM Ahl_Visits_B;