DBA Data[Home] [Help]

APPS.FII_SETUP_VAL_C dependencies on GL_ENCUMBRANCE_TYPES

Line 794: from gl_encumbrance_types);

790: 'FII_PSI_ENCUM_TYPES_COMMITMENT')
791: AND a.view_application_id = 450
792: AND a.language = userenv('LANG')
793: AND upper(a.lookup_code) not in (select upper(encumbrance_type)
794: from gl_encumbrance_types);
795:
796: CURSOR gl_mv_cur IS
797: SELECT object_name
798: FROM sys.dba_objects

Line 1767: gl_encumbrance_types b

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
1771: AND a.language = userenv('LANG')