APPS.AHL_FMP_MR_VISIT_TYPES_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 442: FROM AHL_MR_HEADERS_APP_V

438:
439: CURSOR GetMrDet(c_mr_header_id NUMBER )
440: IS
441: SELECT MR_STATUS_CODE,IMPLEMENT_STATUS_CODE
442: FROM AHL_MR_HEADERS_APP_V
443: WHERE MR_HEADER_ID=c_mr_header_id
444: and MR_STATUS_CODE IN('DRAFT','APPROVAL_REJECTED');
445:
446: