DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_COSTING dependencies on PA_ALLOC_RUNS

Line 907: pa_alloc_runs par

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 */

Line 920: pa_alloc_runs par

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 */

Line 935: pa_alloc_runs par

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 */