APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 87: FROM ahl_mr_relationships r

83: CURSOR is_grp_mr_check(p_mr_header_id IN NUMBER) IS
84: SELECT 'x'
85: FROM DUAL
86: WHERE EXISTS (SELECT r.related_mr_header_id
87: FROM ahl_mr_relationships r
88: WHERE r.mr_header_id = p_mr_header_id
89: AND EXISTS (SELECT m.mr_header_id
90: FROM ahl_mr_headers_b M -- perf bug 6266738
91: WHERE m.mr_header_id = r.related_mr_header_id