APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_VISITS_B

Line 344: FROM ahl_visits_b

340: CURSOR get_org_details_cur(c_visit_id IN NUMBER)
341: IS
342: SELECT organization_id,department_id,
343: project_id
344: FROM ahl_visits_b
345: WHERE visit_id = c_visit_id;
346: --
347: l_visit_id NUMBER;
348: l_department_id NUMBER;

Line 4094: ahl_visits_b b

4090: SELECT a.visit_id,
4091: visit_task_id,
4092: organization_id
4093: FROM ahl_workorders A,
4094: ahl_visits_b b
4095: WHERE workorder_id = c_workorder_id
4096: AND a.visit_id = b.visit_id;
4097:
4098: CURSOR Material_Detail_Cur (c_operation_id IN NUMBER,