APPS.AHL_VISIT_TYPE_PVT dependencies on AHL_MC_HEADERS_B

Line 216: * 2. Removed mc_name from view AHL_VISIT_TYPES_VL, thereby added outer join with table AHL_MC_HEADERS_B.

212:
213: -- cursor to get the visit type corresponding to the visit type id
214: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011
215: * 1. Fetch component visit flag also.
216: * 2. Removed mc_name from view AHL_VISIT_TYPES_VL, thereby added outer join with table AHL_MC_HEADERS_B.
217: */
218: CURSOR get_visit_type(c_visit_type_id in Number) IS
219: SELECT AVTV.visit_type_code,
220: AVTV.visit_type_name,

Line 225: AHL_MC_HEADERS_B AMHB

221: AMHB.name mc_name,
222: AVTV.linked_visit_type_id,
223: AVTV.component_visit_flag
224: FROM AHL_VISIT_TYPES_VL AVTV,
225: AHL_MC_HEADERS_B AMHB
226: WHERE AVTV.visit_type_id = c_visit_type_id
227: AND AVTV.mc_id = AMHB.mc_header_id (+);
228:
229: BEGIN

Line 445: * Removed mc_name from view AHL_VISIT_TYPES_VL, thereby added outer join with table AHL_MC_HEADERS_B.

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: */
447: CURSOR draft_exists(c_par_visit_type_id IN Number) IS
448: SELECT AVTV.visit_type_name,
449: AMHB.name mc_name

Line 451: AHL_MC_HEADERS_B AMHB

447: CURSOR draft_exists(c_par_visit_type_id IN Number) IS
448: SELECT AVTV.visit_type_name,
449: AMHB.name mc_name
450: FROM AHL_VISIT_TYPES_VL AVTV,
451: AHL_MC_HEADERS_B AMHB
452: WHERE AVTV.linked_visit_type_id = c_par_visit_type_id
453: AND AVTV.mc_id = AMHB.mc_header_id (+);
454:
455: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011