APPS.AHL_FMP_MR_VISIT_TYPES_PVT dependencies on AHL_MR_VISIT_TYPES_APP_V

Line 434: FROM AHL_MR_VISIT_TYPES_app_v

430: as
431: CURSOR get_visit_id(c_mr_visit_type_id NUMBER,C_OBJECT_VERSION_NUMBER NUMBER)
432: IS
433: SELECT mr_visit_type_ID
434: FROM AHL_MR_VISIT_TYPES_app_v
435: WHERE mr_visit_type_ID=c_mr_visit_type_id
436: AND OBJECT_VERSION_NUMBER=C_OBJECT_VERSION_NUMBER
437: for update;
438:

Line 452: FROM AHL_mr_visit_typeS_app_v

448:
449: CURSOR CHECK_DUP_VISIT_CODE(c_mr_visit_type_code VARCHAR2,c_mr_header_id NUMBER)
450: IS
451: SELECT MR_VISIT_TYPE_CODE,MR_VISIT_TYPE_ID,MR_HEADER_ID
452: FROM AHL_mr_visit_typeS_app_v
453: WHERE MR_HEADER_ID=c_mr_header_id
454: and MR_VISIT_TYPE_CODE=c_mr_visit_type_CODE;
455:
456: -- Tamal [MEL/CDL] -- Begin changes