APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_VISITS_B

Line 2081: FROM ahl_visits_b

2077:
2078: -- Cursor to get Visit Org Id from the visit.
2079: CURSOR get_visit_org_id_cur(c_visit_id IN NUMBER)IS
2080: SELECT organization_id
2081: FROM ahl_visits_b
2082: WHERE visit_id = C_VISIT_ID
2083: AND ( organization_id IS NOT NULL
2084: OR start_date_time IS NOT NULL
2085: OR department_id IS NOT NULL);