APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_VISITS_B

Line 1293: from ahl_visit_tasks_b vts, ahl_visits_b vst

1289: -- get visit details.
1290: cursor visit_det_csr(p_ue_id IN NUMBER)
1291: is
1292: select 'x'
1293: from ahl_visit_tasks_b vts, ahl_visits_b vst
1294: where vst.visit_id = vts.visit_id
1295: and NVL(vst.status_code,'x') IN ('PARTIALLY RELEASED','RELEASED')
1296: and NVL(vts.status_code,'x') = 'RELEASED'
1297: and vts.unit_effectivity_id = p_ue_id ;

Line 3372: ahl_visits_b vst

3368: Is
3369: Select wo.workorder_name, tsk.visit_id,
3370: wdj.scheduled_start_date, vst.close_date_time
3371: from ahl_workorders wo, ahl_visit_tasks_b tsk, wip_discrete_jobs wdj,
3372: ahl_visits_b vst
3373: where wo.visit_task_id = tsk.visit_task_id
3374: and tsk.visit_id = vst.visit_id
3375: and wdj.wip_entity_id = wo.wip_entity_id
3376: and tsk.unit_effectivity_id = p_ue_id

Line 3432: FROM AHL_VISIT_TASKS_B A, ahl_visits_b vst

3428: -- get inventory item and organization id.
3429: CURSOR default_item_org_id(p_ue_id IN NUMBER) IS
3430: SELECT A.inventory_item_id,
3431: vst.organization_id
3432: FROM AHL_VISIT_TASKS_B A, ahl_visits_b vst
3433: WHERE a.visit_id = vst.visit_id
3434: and A.unit_effectivity_id = p_ue_id
3435: AND A.task_type_code IN ('SUMMARY','UNASSOCIATED')
3436: AND rownum = 1;