APPS.AD_PATCH dependencies on AD_SNAPSHOT_FILES

Line 308: ad_snapshot_files is sufficient.

304: For is_file_copied, the relevant question is "does the file with a
305: specific version or higher, exists on the file system" ?
306: Not whether it was explicitly copied or not by a patch.
307: And for that, just a file with a exact or higher version in
308: ad_snapshot_files is sufficient.
309: ***********************************************************************/
310:
311: function find_max_applied_version_indb(p_file_id in number,
312: p_snapshot_id in number)

Line 317: from ad_file_versions v, ad_snapshot_files s

313: return varchar2
314: is
315: cursor MAX_VER_CUR(p_file_id in ad_files.file_id%TYPE) is
316: select v.version
317: from ad_file_versions v, ad_snapshot_files s
318: where s.file_id = v.file_id
319: and s.file_id = p_file_id
320: and s.snapshot_id = p_snapshot_id
321: and v.file_version_id = s.file_version_id;