DBA Data[Home] [Help]

APPS.XLA_MO_REPORTING_API dependencies on FND_LOOKUPS

Line 172: l_reporting_level_name fnd_lookups.meaning%TYPE;

168: --
169: FUNCTION Get_Reporting_Level_Name
170: RETURN VARCHAR2
171: IS
172: l_reporting_level_name fnd_lookups.meaning%TYPE;
173:
174: BEGIN
175: SELECT meaning
176: INTO l_reporting_level_name

Line 177: FROM fnd_lookups

173:
174: BEGIN
175: SELECT meaning
176: INTO l_reporting_level_name
177: FROM fnd_lookups
178: WHERE lookup_type = 'XLA_MO_REPORTING_LEVEL'
179: AND lookup_code = g_reporting_level;
180:
181: RETURN l_reporting_level_name;

Line 245: FROM fnd_lookups lp

241: , x_top_reporting_level IN VARCHAR2
242: )
243: IS
244: SELECT 1
245: FROM fnd_lookups lp
246: WHERE lookup_type = 'XLA_MO_REPORTING_LEVEL'
247: AND lookup_code = x_reporting_level
248: AND TO_NUMBER(lookup_code) >=
249: TO_NUMBER(x_top_reporting_level);