DBA Data[Home] [Help]

APPS.FEM_MAPPING_PREVIEW_UTIL_PKG dependencies on FEM_TABLE_CLASS_ASSIGNMT_V

Line 1433: FROM fem_table_class_assignmt_v

1429: --
1430: -- Returns T if table is a "ledger" table and F otherwise
1431: CURSOR c_is_ledger(cv_table_name VARCHAR2) IS
1432: SELECT decode(count(*),0,'F','T')
1433: FROM fem_table_class_assignmt_v
1434: WHERE table_name = cv_table_name
1435: AND substr(table_classification_code,-6) = 'LEDGER';
1436:
1437: -- Returns T if table is an "account or transaction" table and F otherwise

Line 1440: FROM fem_table_class_assignmt_v

1436:
1437: -- Returns T if table is an "account or transaction" table and F otherwise
1438: CURSOR c_is_acct_trans(cv_table_name VARCHAR2) IS
1439: SELECT decode(count(*),0,'F','T')
1440: FROM fem_table_class_assignmt_v
1441: WHERE table_name = cv_table_name
1442: AND table_classification_code IN ('ACCOUNT_PROFITABILITY',
1443: 'TRANSACTION_PROFITABILITY');
1444: --