APPS.AD_PATCH_HISTORY_PKG dependencies on AD_PATCH_RUN_BUG_ACTIONS

Line 89: 'ad_patch_run_bug_actions prba '||

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 '||
90: 'where prba.common_action_id = pca.common_action_id '||
91: 'and prba.file_id = f.file_id '||
92: 'and prba.patch_run_bug_id = prb.patch_run_bug_id '||
93: 'and prb.patch_run_id = pr.patch_run_id '||

Line 176: update ad_patch_run_bug_actions prba

172: l_cur_fetch := c_actions%rowcount - l_prev_fetch;
173: l_prev_fetch := c_actions%rowcount;
174:
175: forall l_row in 1..l_cur_fetch
176: update ad_patch_run_bug_actions prba
177: set prba.onsite_file_version_id =
178: (
179: select
180: /*+ USE_NL(E)

Line 287: 'ad_patch_run_bug_actions prba '||

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 '||
289: 'and prba.patch_run_bug_id = prb.patch_run_bug_id '||
290: 'and prb.patch_run_id = pr.patch_run_id '||
291: 'and prba.onsite_file_version_id = fv.file_version_id '||