APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_WORKORDERS

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 3309: l_wo_name ahl_workorders.workorder_name%TYPE;

3305: l_msg_count NUMBER;
3306: l_msg_data VARCHAR2(2000);
3307: l_summary VARCHAR2(2000); --cs_incidents_all_b.summary%TYPE;
3308:
3309: l_wo_name ahl_workorders.workorder_name%TYPE;
3310: l_individual_owner NUMBER;
3311: l_group_owner NUMBER;
3312: l_individual_type VARCHAR2(30);
3313: