466: itt.tracking_type = tt.tracking_type AND
467: tt.s_tracking_type = p_requirements_type AND
468: NOT EXISTS
469: (SELECT 'x' 470: FROM igs_tr_step its 471: WHERE its.tracking_id = ar.tracking_id AND
472: (its.step_completion_ind = 'Y' OR
473: its.by_pass_ind = 'Y') -- bug 2776548
474: )