APPS.OKS_IMPORT_REPORT dependencies on FND_LOOKUPS

Line 60: FROM FND_LOOKUPS FL,

56: INNER_Q.Covered_Levels_Stat Covered_Levels_Stat,
57: INNER_Q.Usage_Counters_Stat Usage_Counters_Stat,
58: INNER_Q.Sales_Credits_Stat Sales_Credits_Stat,
59: INNER_Q.Notes_Stat Notes_Stat
60: FROM FND_LOOKUPS FL,
61: (SELECT OIS.STATISTIC_TYPE_ID Statistic_type,
62: SUM(OIS.HEADERS_STAT) Headers_Stat,
63: SUM(OIS.LINES_STAT) Lines_Stat,
64: SUM(OIS.COVERED_LEVELS_STAT) Covered_Levels_Stat,

Line 290: select meaning into l_mode from fnd_lookups where lookup_type = 'OKS_IMPORT_MODE' and lookup_code = P_mode;

286: where request_id = P_parent_request_id;
287:
288: l_stmt_num := 20;
289:
290: select meaning into l_mode from fnd_lookups where lookup_type = 'OKS_IMPORT_MODE' and lookup_code = P_mode;
291:
292: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10) || fnd_global.local_chr(10) || fnd_global.local_chr(10));
293: FND_FILE.put_line(FND_FILE.OUTPUT, lpad('Import Execution Report', 70) || lpad('Date: ', 32) || l_report_date);
294: FND_FILE.put_line(FND_FILE.OUTPUT, fnd_global.local_chr(10));