APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_VISIT_TASKS_B

Line 1210: from ahl_visit_tasks_b vts, ahl_visits_b vst

1206: -- get visit details.
1207: cursor visit_det_csr(p_ue_id IN NUMBER)
1208: is
1209: select 'x'
1210: from ahl_visit_tasks_b vts, ahl_visits_b vst
1211: where vst.visit_id = vts.visit_id
1212: and NVL(vst.status_code,'x') IN ('PARTIALLY RELEASED','RELEASED')
1213: and NVL(vts.status_code,'x') = 'RELEASED'
1214: and vts.unit_effectivity_id = p_ue_id ;

Line 3216: from ahl_workorders wo, ahl_visit_tasks_b tsk

3212:
3213: CURSOR GetWoName(p_ue_id IN NUMBER)
3214: Is
3215: Select wo.workorder_name, tsk.visit_id
3216: from ahl_workorders wo, ahl_visit_tasks_b tsk
3217: where wo.visit_task_id = tsk.visit_task_id
3218: and tsk.unit_effectivity_id = p_ue_id
3219: and tsk.task_type_code IN ('SUMMARY','UNASSOCIATED');
3220:

Line 3259: FROM AHL_VISIT_TASKS_B A, ahl_visits_b vst

3255: -- get inventory item and organization id.
3256: CURSOR default_item_org_id(p_ue_id IN NUMBER) IS
3257: SELECT A.inventory_item_id,
3258: vst.organization_id
3259: FROM AHL_VISIT_TASKS_B A, ahl_visits_b vst
3260: WHERE a.visit_id = vst.visit_id
3261: and A.unit_effectivity_id = p_ue_id
3262: AND A.task_type_code IN ('SUMMARY','UNASSOCIATED')
3263: AND rownum = 1;