APPS.AHL_VISIT_TYPE_PVT dependencies on AHL_VISIT_TYPE_STAGES_B_S

Line 441: SELECT AHL_VISIT_TYPE_STAGES_B_S.nextVal

437: FROM AHL_VISIT_TYPE_STAGES_B
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.

Line 929: FROM AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP

925:
926: UNION ALL
927:
928: SELECT MAX(STAGES.LAST_UPDATE_DATE) LAST_UPDATE_DATE
929: FROM AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP
930: WHERE STAGES.VISIT_TYPE_ID = VST_TYP.VISIT_TYPE_ID
931: AND VST_TYP.VISIT_TYPE_ID = C_VISIT_TYPE_ID
932:
933: UNION ALL

Line 936: FROM AHL_VST_TYP_STAGE_LINKS LINKS, AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP

932:
933: UNION ALL
934:
935: SELECT MAX(LINKS.LAST_UPDATE_DATE) LAST_UPDATE_DATE
936: FROM AHL_VST_TYP_STAGE_LINKS LINKS, AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP
937: WHERE VST_TYP.VISIT_TYPE_ID = STAGES.VISIT_TYPE_ID
938: AND STAGES.VISIT_TYPE_STAGE_ID = LINKS.OBJECT_ID
939: AND VST_TYP.VISIT_TYPE_ID = C_VISIT_TYPE_ID
940:

Line 944: FROM AHL_VST_TYP_STG_TYP_ASOC STG_TYP, AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP

940:
941: UNION ALL
942:
943: SELECT MAX(STG_TYP.LAST_UPDATE_DATE) LAST_UPDATE_DATE
944: FROM AHL_VST_TYP_STG_TYP_ASOC STG_TYP, AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP
945: WHERE VST_TYP.VISIT_TYPE_ID = STAGES.VISIT_TYPE_ID
946: AND STAGES.VISIT_TYPE_STAGE_ID = STG_TYP.VISIT_TYPE_STAGE_ID
947: AND VST_TYP.VISIT_TYPE_ID = C_VISIT_TYPE_ID) QRSLT;
948: