APPS.AHL_FMP_MR_HEADER_PVT dependencies on AHL_MR_VISIT_TYPES

Line 893: From AHL_MR_VISIT_TYPES

889: THEN
890: l_check_impl_status:=0;
891:
892: Select count(*) INTO l_check_impl_status
893: From AHL_MR_VISIT_TYPES
894: WHERE MR_HEADER_ID=p_x_mr_header_rec.MR_HEADER_ID;
895:
896: IF nvl(l_check_impl_status,0) >0
897: THEN

Line 1337: FROM AHL_MR_VISIT_TYPES

1333: -- Cursor to get visit types count for an MR
1334: CURSOR Get_Visit_Type_Count(c_mr_header_id NUMBER)
1335: IS
1336: SELECT COUNT(*)
1337: FROM AHL_MR_VISIT_TYPES
1338: WHERE mr_header_id = c_mr_header_id;
1339:
1340: l_count NUMBER;
1341: l_old_impl_status AHL_MR_HEADERS_B.implement_status_code%TYPE;