APPS.FEM_UD_PKG dependencies on FEM_TABLE_CLASS_ASSIGNMT

Line 1921: FROM fem_pl_tables t2, fem_table_class_assignmt_v t

1917: AND r.cal_period_id = v_cal_period_id
1918: AND r.output_dataset_code = v_output_dataset_code)
1919: AND t1.table_name IN (
1920: SELECT t2.table_name
1921: FROM fem_pl_tables t2, fem_table_class_assignmt_v t
1922: WHERE t2.request_id = p_request_id
1923: AND t2.object_id = p_object_id
1924: AND t2.statement_type = 'INSERT'
1925: AND t2.table_name = t.table_name

Line 1947: FROM fem_table_class_assignmt_v t

1943: WHERE request_id = p_request_id
1944: AND object_id = p_object_id
1945: AND c.table_name IN (
1946: SELECT t.table_name
1947: FROM fem_table_class_assignmt_v t
1948: WHERE t.table_classification_code IN
1949: ('ACCOUNT_PROFITABILITY','FTP_CASH_FLOW',
1950: 'FTP_NON_CASH_FLOW','FTP_OPTION_COST') );
1951:

Line 2010: FROM fem_pl_tables t2, fem_table_class_assignmt_v t

2006: AND r.cal_period_id = v_cal_period_id
2007: AND r.output_dataset_code = v_output_dataset_code)
2008: AND t1.table_name IN (
2009: SELECT t2.table_name
2010: FROM fem_pl_tables t2, fem_table_class_assignmt_v t
2011: WHERE t2.table_name = t.table_name
2012: AND t.table_classification_code IN
2013: ('ACCOUNT_PROFITABILITY','FTP_CASH_FLOW',
2014: 'FTP_NON_CASH_FLOW','FTP_OPTION_COST')

Line 2043: FROM fem_table_class_assignmt_v t

2039: FROM fem_ud_upd_dep_t d
2040: WHERE d.upd_dep_calc_id = x_upd_dep_calc_id)
2041: AND c.table_name IN (
2042: SELECT t.table_name
2043: FROM fem_table_class_assignmt_v t
2044: WHERE t.table_classification_code IN
2045: ('ACCOUNT_PROFITABILITY','FTP_CASH_FLOW',
2046: 'FTP_NON_CASH_FLOW','FTP_OPTION_COST') )
2047: AND (c.table_name, c.column_name) NOT IN (

Line 3448: v_tab_class FEM_TABLE_CLASS_ASSIGNMT.table_classification_code%TYPE;

3444: v_undo_flag VARCHAR2(1);
3445: v_msg_count NUMBER;
3446: v_msg_data VARCHAR2(32000);
3447: v_tab_name FEM_PL_TABLES.table_name%TYPE;
3448: v_tab_class FEM_TABLE_CLASS_ASSIGNMT.table_classification_code%TYPE;
3449: v_stmt_type FEM_PL_TABLES.statement_type%TYPE;
3450: v_col_name FEM_PL_TAB_UPDATED_COLS.column_name%TYPE;
3451: v_object_name FEM_OBJECT_CATALOG_VL.object_name%TYPE;
3452:

Line 3469: from fem_table_class_assignmt_v) t

3465: 'FTP_CASH_FLOW','ZERO_COLUMN_BY_PERIOD',
3466: 'FTP_NON_CASH_FLOW','ZERO_COLUMN_BY_PERIOD',
3467: 'FTP_OPTION_COST','ZERO_COLUMN_BY_PERIOD',NULL)
3468: undo_type, table_name
3469: from fem_table_class_assignmt_v) t
3470: WHERE p.request_id = p_request_id
3471: AND p.object_id = p_object_id
3472: AND p.table_name = t.table_name(+)
3473: ORDER BY table_name, statement_type;

Line 3608: FROM fem_table_class_assignmt_v

3604: -- Determine MP step name
3605: BEGIN
3606: SELECT max(decode(table_classification_code,'GENERIC_DATA_TABLE',
3607: 'GENERIC_DATA_TABLE','LEDGER')) INTO v_mp_step_name
3608: FROM fem_table_class_assignmt_v
3609: WHERE (table_classification_code = 'GENERIC_DATA_TABLE'
3610: OR table_classification_code like '%LEDGER')
3611: AND table_name = atbl.table_name;
3612: EXCEPTION

Line 4115: FROM fem_table_class_assignmt_v

4111: v_tab_class := null;
4112: BEGIN
4113: SELECT max(table_classification_code)
4114: INTO v_tab_class
4115: FROM fem_table_class_assignmt_v
4116: WHERE table_classification_code NOT IN ('CUSTOMER_PROFIT_RESULT',
4117: 'TRANSACTION_PROFITABILITY','ACCOUNT_PROFITABILITY',
4118: 'FTP_CASH_FLOW','FTP_NON_CASH_FLOW','FTP_OPTION_COST')
4119: AND table_name = v_tab_name;