APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_VISIT_TASKS_B

Line 378: FROM ahl_visit_tasks_b

374: CURSOR get_visit_task_cur (c_visit_task_id IN NUMBER)
375: IS
376: SELECT visit_id,
377: department_id,project_task_id
378: FROM ahl_visit_tasks_b
379: WHERE visit_task_id = c_visit_task_id;
380: --
381: CURSOR get_org_details_cur(c_visit_id IN NUMBER)
382: IS

Line 1275: AHL_VISIT_TASKS_B AVTB

1271: CURSOR Check_stg_workorder_csr (c_workorder_id NUMBER)
1272: IS
1273: SELECT 1
1274: FROM AHL_WORKORDERS AHLW,
1275: AHL_VISIT_TASKS_B AVTB
1276:
1277: WHERE AHLW.workorder_id = c_workorder_id
1278: AND AHLW.status_code = '17'
1279: AND AHLW.visit_task_id = AVTB.visit_task_id