903: select 1
904: from dual
905: where exists ( select null
906: from pa_alloc_run_sources pars,
907: pa_alloc_runs par
908: where par.rule_id = pars.rule_id
909: and pars.project_id = p_proj_id
910: and par.run_id = pars.run_id
911: /* and par.run_status <> 'RS' commented for bug#2446122 */
916: select 1
917: from dual
918: where exists ( select null
919: from pa_alloc_run_targets part,
920: pa_alloc_runs par
921: where par.rule_id = part.rule_id
922: and part.project_id = p_proj_id
923: and par.run_id = part.run_id
924: /* and par.run_status <> 'RS' commented for bug#2446122 */
931: select 1
932: from dual
933: where exists ( select null
934: from pa_alloc_rules_all para,
935: pa_alloc_runs par
936: where par.rule_id = para.rule_id
937: and para.offset_project_id = p_proj_id
938: /* and par.run_status <> 'RS' commented for bug#2446122 */
939: and par.run_status not in ( 'RS', 'RV') /* Added for bug#2446122 */