APPS.AHL_VWP_VISITS_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 5248: WHERE exists (select 'X' from AHL_SCHEDULE_MATERIALS_V where VISIT_ID = x_visit_id);*/

5244:
5245: -- To find whether the visit has any materials
5246: CURSOR c_Material(x_visit_id IN NUMBER) IS
5247: /* SELECT 'X' FROM DUAL
5248: WHERE exists (select 'X' from AHL_SCHEDULE_MATERIALS_V where VISIT_ID = x_visit_id);*/
5249:
5250: -- AnRaj: Changed for fixing the perf bug 4919502
5251: SELECT 'x' FROM ahl_schedule_materials
5252: WHERE status <> 'DELETED'

Line 5251: SELECT 'x' FROM ahl_schedule_materials

5247: /* SELECT 'X' FROM DUAL
5248: WHERE exists (select 'X' from AHL_SCHEDULE_MATERIALS_V where VISIT_ID = x_visit_id);*/
5249:
5250: -- AnRaj: Changed for fixing the perf bug 4919502
5251: SELECT 'x' FROM ahl_schedule_materials
5252: WHERE status <> 'DELETED'
5253: AND visit_id = x_visit_id;
5254:
5255: c_Material_rec c_Material%ROWTYPE;

Line 7830: ahl_schedule_materials asm

7826: asm.uom,
7827: asm.requested_date,
7828: asm.scheduled_date asm_scheduled_date
7829: FROM ahl_visit_task_matrl_v vtm,
7830: ahl_schedule_materials asm
7831: WHERE vtm.visit_id = p_visit_id
7832: AND asm.scheduled_material_id = vtm.schedule_material_id;
7833:
7834: l_visit_mtrls_rec visit_mtrls_cur%ROWTYPE;