APPS.FII_SETUP_VAL_C dependencies on FND_LOOKUP_VALUES

Line 788: FROM fnd_lookup_values a

784: SELECT a.lookup_code,
785: decode(a.lookup_type,
786: 'FII_PSI_ENCUM_TYPES_OBLIGATION', 'Obligation',
787: 'FII_PSI_ENCUM_TYPES_COMMITMENT', 'Commitment') lookup_type
788: FROM fnd_lookup_values a
789: WHERE a.lookup_type in ( 'FII_PSI_ENCUM_TYPES_OBLIGATION',
790: 'FII_PSI_ENCUM_TYPES_COMMITMENT')
791: AND a.view_application_id = 450
792: AND a.language = userenv('LANG')

Line 1766: FROM fnd_lookup_values a,

1762: fii_util.put_line('START CHECK: Encumbrance Type Mappings');
1763:
1764: SELECT count(*)
1765: INTO l_cnt
1766: FROM fnd_lookup_values a,
1767: gl_encumbrance_types b
1768: WHERE a.lookup_type in ( 'FII_PSI_ENCUM_TYPES_OBLIGATION',
1769: 'FII_PSI_ENCUM_TYPES_COMMITMENT')
1770: AND a.view_application_id = 450