APPS.AD_PATCH_HISTORY_PKG dependencies on AD_PATCH_RUNS

Line 85: 'from ad_patch_runs pr, '||

81: 'pr.appl_top_id '||
82: 'order by pr.end_date, '||
83: 'decode(pca.action_code, ''copy'', 1, 2) '||
84: 'rows between unbounded preceding and 1 preceding) '||
85: 'from ad_patch_runs pr, '||
86: 'ad_patch_run_bugs prb, '||
87: 'ad_files f, '||
88: 'ad_patch_common_actions pca, '||
89: 'ad_patch_run_bug_actions prba '||

Line 233: and exists (select 'x' from ad_patch_runs);

229: select 'x'
230: into dummy
231: from dual
232: where not exists (select 'x' from ad_check_files)
233: and exists (select 'x' from ad_patch_runs);
234: --
235: --
236: execute immediate 'insert into ad_check_files '||
237: '( '||

Line 284: 'ad_patch_runs pr, '||

280: 'fv.version_segment10 desc, '||
281: 'fv.translation_level desc) as rank1 '||
282: 'from '||
283: 'ad_file_versions fv, '||
284: 'ad_patch_runs pr, '||
285: 'ad_patch_run_bugs prb, '||
286: 'ad_patch_common_actions pca, '||
287: 'ad_patch_run_bug_actions prba '||
288: 'where prba.common_action_id = pca.common_action_id '||