499: WHERE bug_number = to_char(p_bug_number)
500: AND ARU_RELEASE_NAME = p_release)
501: AND snapshot_id =
502: (SELECT snapshot_id
503: FROM ad_snapshots
504: WHERE snapshot_name = 'GLOBAL_VIEW'
505: and snapshot_type = 'G');
506: ELSE
507:
513: AND baseline_name = p_baseline
514: AND ARU_RELEASE_NAME = p_release)
515: AND snapshot_id =
516: (SELECT snapshot_id
517: FROM ad_snapshots
518: WHERE snapshot_name = 'GLOBAL_VIEW'
519: and snapshot_type = 'G');
520: END IF;
521: