DBA Data[Home] [Help]

APPS.FND_MO_REPORTING_API dependencies on FND_LOOKUPS

Line 310: l_reporting_level_name fnd_lookups.meaning%TYPE;

306: --
307: FUNCTION Get_Reporting_Level_Name
308: RETURN VARCHAR2
309: IS
310: l_reporting_level_name fnd_lookups.meaning%TYPE;
311:
312: BEGIN
313: SELECT meaning
314: INTO l_reporting_level_name

Line 315: FROM fnd_lookups

311:
312: BEGIN
313: SELECT meaning
314: INTO l_reporting_level_name
315: FROM fnd_lookups
316: WHERE lookup_type = 'FND_MO_REPORTING_LEVEL'
317: AND lookup_code = g_reporting_level;
318:
319: RETURN l_reporting_level_name;

Line 384: FROM fnd_lookups lp

380: , x_top_reporting_level IN VARCHAR2
381: )
382: IS
383: SELECT 1
384: FROM fnd_lookups lp
385: WHERE lookup_type = 'FND_MO_REPORTING_LEVEL'
386: AND lookup_code = x_reporting_level
387: AND TO_NUMBER(trim(lookup_code)) >=
388: TO_NUMBER(trim(x_top_reporting_level));