APPS.FEM_REFRESH_ENG_PKG dependencies on AD_FILES

Line 409: -- This cursor joins to AD_FILES so that we guarantee to run only those

405: e_fndload_error EXCEPTION;
406: e_concurrent_manager EXCEPTION;
407: e_procedure_error EXCEPTION;
408:
409: -- This cursor joins to AD_FILES so that we guarantee to run only those
410: -- files that have been installed and that we run for all languages
411: cursor c_ldt_files IS
412: SELECT R.file_name, ALDT.subdir file_directory_path, R.file_product_prefix,
413: R.lctfile_name, ALCT.subdir lctfile_directory_path, R.lctfile_product_prefix,

Line 418: FROM ad_files) ALDT,

414: substr(ALDT.subdir,instr(ALDT.subdir,'/',-1,1)+1,(length(ALDT.subdir) - instr(ALDT.subdir,'/',-1,1))+1) FILE_LANG,
415: DECODE(substr(ALDT.subdir,instr(ALDT.subdir,'/',-1,1)+1,(length(ALDT.subdir) - instr(ALDT.subdir,'/',-1,1))+1),'US','1',substr(ALDT.subdir,instr(ALDT.subdir,'/',-1,1)+1,(length(ALDT.subdir) - instr(ALDT.subdir,'/',-1,1))+1)) ORDER_SEQ
416: FROM fem_rfsh_files R,
417: (SELECT distinct filename, subdir
418: FROM ad_files) ALDT,
419: (SELECT distinct filename, subdir
420: FROM ad_files
421: WHERE substr(subdir,1,5) = 'patch') ALCT
422: WHERE R.file_type = 'LDT'

Line 420: FROM ad_files

416: FROM fem_rfsh_files R,
417: (SELECT distinct filename, subdir
418: FROM ad_files) ALDT,
419: (SELECT distinct filename, subdir
420: FROM ad_files
421: WHERE substr(subdir,1,5) = 'patch') ALCT
422: WHERE R.file_type = 'LDT'
423: AND UPPER(R.file_name) = UPPER(ALDT.filename)
424: AND UPPER(R.lctfile_name) = UPPER(ALCT.filename)