DBA Data[Home] [Help]

APPS.AHL_VISIT_TYPE_PVT dependencies on DUAL

Line 442: FROM dual;

438: WHERE VISIT_TYPE_ID = c_visit_type_id;
439:
440: CURSOR get_seq_stage_id IS
441: SELECT AHL_VISIT_TYPE_STAGES_B_S.nextVal
442: FROM dual;
443:
444: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011,
445: * Removed mc_name from view AHL_VISIT_TYPES_VL, thereby added outer join with table AHL_MC_HEADERS_B.
446: */