APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on FND_LOOKUPS

Line 2630: FROM fnd_lookups

2626: BEGIN
2627: IF p_report_name = 'JEBEVA06' THEN
2628: SELECT meaning
2629: INTO l_detail_summary
2630: FROM fnd_lookups
2631: WHERE lookup_type = 'JEBE_REPORT_FORMAT'
2632: AND lookup_code = P_REPORT_FORMAT
2633: AND p_report_name = 'JEBEVA06';
2634: RETURN l_detail_summary;

Line 2693: fnd_lookups fl

2689: l_starting_limit := 0;
2690: SELECT NVL(jiy.adjusted_limit_amount, 0)
2691: INTO l_starting_limit
2692: FROM je_it_year_ex_limit JIY,
2693: fnd_lookups fl
2694: WHERE fl.lookup_type = 'JEIT_MONTH'
2695: AND JIY.month = fl.lookup_code
2696: AND JIY.year = to_char(l_period_date,'RRRR')
2697: AND JIY.month = to_char(l_period_date,'MM')