APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_MR_RELATIONSHIPS

Line 98: FROM ahl_mr_relationships r

94: CURSOR is_grp_mr_check(p_mr_header_id IN NUMBER) IS
95: SELECT 'x'
96: FROM DUAL
97: WHERE EXISTS (SELECT r.related_mr_header_id
98: FROM ahl_mr_relationships r
99: WHERE r.mr_header_id = p_mr_header_id
100: AND EXISTS (SELECT m.mr_header_id
101: FROM ahl_mr_headers_b M -- perf bug 6266738
102: WHERE m.mr_header_id = r.related_mr_header_id