4002:
4003: -- To find whether the visit has any materials
4004: CURSOR c_Material(x_visit_id IN NUMBER) IS
4005: /* SELECT 'X' FROM DUAL
4006: WHERE exists (select 'X' from AHL_SCHEDULE_MATERIALS_V where VISIT_ID = x_visit_id);*/
4007:
4008: -- AnRaj: Changed for fixing the perf bug 4919502
4009: SELECT 'x' FROM ahl_schedule_materials
4010: WHERE status <> 'DELETED'
4005: /* SELECT 'X' FROM DUAL
4006: WHERE exists (select 'X' from AHL_SCHEDULE_MATERIALS_V where VISIT_ID = x_visit_id);*/
4007:
4008: -- AnRaj: Changed for fixing the perf bug 4919502
4009: SELECT 'x' FROM ahl_schedule_materials
4010: WHERE status <> 'DELETED'
4011: AND visit_id = x_visit_id;
4012:
4013: c_Material_rec c_Material%ROWTYPE;