APPS.FND_IMP_PKG dependencies on FND_LOOKUPS

Line 740: (select lower(lu.lookup_code) from fnd_lookups lu

736: select decode(count(fcv.file_type),0,0,1) into v_req_trans
737: from fnd_imp_filetypecount_vl fcv
738: where lower(fcv.file_type) in
739: --('fmb','fmx','rdf','ldt','ildt','jtl','msg','msb','res')
740: (select lower(lu.lookup_code) from fnd_lookups lu
741: where lu.lookup_type = 'OAM_PIA_TRANS_FILE_TYPES')
742: and ( fcv.upgrade > 0 or fcv.new > 0 )
743: and fcv.snapshot_id = snapshot_id__
744: and fcv.bug_no = v_bug.virtual_bug_no;