APPS.AD_PATCH dependencies on AD_SNAPSHOT_FILES

Line 299: ad_snapshot_files is sufficient.

295: For is_file_copied, the relevant question is "does the file with a
296: specific version or higher, exists on the file system" ?
297: Not whether it was explicitly copied or not by a patch.
298: And for that, just a file with a exact or higher version in
299: ad_snapshot_files is sufficient.
300: ***********************************************************************/
301:
302: function find_max_applied_version_indb(p_file_id in number,
303: p_snapshot_id in number)

Line 308: from ad_file_versions v, ad_snapshot_files s

304: return varchar2
305: is
306: cursor MAX_VER_CUR(p_file_id in ad_files.file_id%TYPE) is
307: select v.version
308: from ad_file_versions v, ad_snapshot_files s
309: where s.file_id = v.file_id
310: and s.file_id = p_file_id
311: and s.snapshot_id = p_snapshot_id
312: and v.file_version_id = s.file_version_id;