APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on FND_LOOKUPS

Line 2761: ,fnd_lookups lc

2757: ,p.ibge_city_code
2758: ,p.municipal_inscription
2759: ,p.suframa_inscription_number
2760: FROM jl_br_sped_partic_codes p
2761: ,fnd_lookups lc
2762: WHERE ledger_id = g_ledger_id
2763: AND lc.lookup_type ='JLBR_CBANK_COUNTRY_CODES'
2764: AND lc.lookup_code = p.country_code
2765: AND p.enabled_flag = 'Y'

Line 4907: FROM fnd_lookups fl

4903: AND j.period_name in (g_period_name,g_adjustment_period_name)
4904: AND ((j.default_effective_date between g_start_date and g_end_date)
4905: OR (j.default_effective_date between g_adjustment_period_start_date and g_adjustment_period_end_date))
4906: AND j.je_source NOT IN (SELECT fl.lookup_code
4907: FROM fnd_lookups fl
4908: WHERE fl.lookup_type = 'JLBR_SPED_LEGACY_SOURCES'
4909: AND fl.ENABLED_FLAG = 'Y')
4910: AND EXISTS (SELECT 1
4911: FROM gl_je_lines jl

Line 6506: FROM fnd_lookups

6502: END IF;
6503:
6504: SELECT SUBSTR(meaning,1,80)
6505: INTO l_booktype_desc
6506: FROM fnd_lookups
6507: WHERE lookup_type = 'JLBR_SPED_BOOK_TYPES'
6508: AND lookup_code = g_bookkeeping_type;
6509:
6510: BEGIN

Line 7502: FROM fnd_lookups

7498: l_journalsource_check := 0;
7499:
7500: SELECT 1
7501: INTO l_journalsource_check
7502: FROM fnd_lookups
7503: WHERE lookup_type = 'JLBR_SPED_LEGACY_SOURCES'
7504: AND lookup_code in ('AX Inventory','AX Payables','AX Receivables','Assets','Average Consolidation',
7505: 'Budget Journal','Carryforward','Consolidation','Conversion','Encumbrance',
7506: 'Inflation','Intercompany','Inventory','Manual','Manufacturing','MassAllocation',