DBA Data[Home] [Help]

APPS.BIS_BIA_RSG_LOG_MGMNT dependencies on AD_FILES

Line 153: , ad_files af

149: cursor c_mv_patch_applied is
150: SELECT af.filename filename
151: , MAX(acf.creation_date) file_creation_date
152: FROM ad_check_files acf
153: , ad_files af
154: WHERE af.file_id = acf.file_id
155: AND (
156: filename =p_base_object_name || '.xdf'
157: OR filename = LOWER(p_base_object_name) || '.xdf'

Line 170: , ad_files af

166: cursor c_log_patch_applied is
167: SELECT af.filename filename
168: , MAX(acf.creation_date) file_creation_date
169: FROM ad_check_files acf
170: , ad_files af
171: WHERE af.file_id = acf.file_id
172: AND (
173: filename =upper(p_base_object_name)||'_MLOG' || '.xdf'
174: OR filename = LOWER(p_base_object_name)||'_mlog'|| '.xdf'