APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on FND_LOOKUPS

Line 1402: FROM fnd_lookups

1398: BEGIN
1399: IF p_report_name = 'JEBEVA06' THEN
1400: SELECT meaning
1401: INTO l_detail_summary
1402: FROM fnd_lookups
1403: WHERE lookup_type = 'JEBE_REPORT_FORMAT'
1404: AND lookup_code = P_REPORT_FORMAT
1405: AND p_report_name = 'JEBEVA06';
1406: RETURN l_detail_summary;

Line 1457: fnd_lookups fl

1453: l_starting_limit := 0;
1454: SELECT NVL(jiy.adjusted_limit_amount, 0)
1455: INTO l_starting_limit
1456: FROM je_it_year_ex_limit JIY,
1457: fnd_lookups fl
1458: WHERE fl.lookup_type = 'JEIT_MONTH'
1459: AND JIY.month = fl.lookup_code
1460: AND JIY.year = to_char(P_PERIOD,'RRRR')
1461: AND JIY.month = to_char(P_PERIOD,'MM')