APPS.FII_SETUP_VAL_C dependencies on DBA_OBJECTS

Line 798: FROM sys.dba_objects

794: from gl_encumbrance_types);
795:
796: CURSOR gl_mv_cur IS
797: SELECT object_name
798: FROM sys.dba_objects
799: WHERE object_name IN ( 'FII_GL_AGRT_SUM_MV', 'FII_GL_BASE_MAP_MV',
800: 'FII_GL_BASE_MV', 'FII_GL_MGMT_CCC_MV',
801: 'FII_GL_MGMT_SUM_MV', 'FII_GL_TREND_SUM_MV')
802: AND object_type = 'MATERIALIZED VIEW';

Line 806: FROM sys.dba_objects

802: AND object_type = 'MATERIALIZED VIEW';
803:
804: CURSOR ap_mv_cur IS
805: SELECT object_name
806: FROM sys.dba_objects
807: WHERE object_name IN ( 'FII_AP_HATY_XB_MV', 'FII_AP_HCAT_B_MV',
808: 'FII_AP_HCAT_IB_MV', 'FII_AP_HCAT_I_MV',
809: 'FII_AP_HHIST_B_MV', 'FII_AP_HHIST_IB_MV',
810: 'FII_AP_HHIST_I_MV', 'FII_AP_HLIA_IB_MV',

Line 822: FROM sys.dba_objects

818: AND object_type = 'MATERIALIZED VIEW';
819:
820: CURSOR ar_mv_cur IS
821: SELECT object_name
822: FROM sys.dba_objects
823: WHERE object_name IN ( 'FII_AR_BILLING_ACT_AGRT_MV',
824: 'FII_AR_BILLING_ACT_BASE_MV',
825: 'FII_AR_DIMENSIONS_MV',
826: 'FII_AR_DISPUTES_AGRT_MV',

Line 1751: FROM sys.dba_objects

1747: -- Validate encumbrance type mappings for PSI customers (R12 only)
1748: ----------------------------------------------------------------------
1749: SELECT count(*)
1750: INTO l_cnt
1751: FROM sys.dba_objects
1752: WHERE object_name = 'FII_ENCUM_TYPE_MAPPINGS';
1753:
1754: IF ((l_cnt > 0) AND (l_industry_profile = 'G')) THEN
1755: fii_util.put_line(' ');