DBA Data[Home] [Help]

APPS.FEM_INTG_NEW_DIM_MEMBER_PKG dependencies on FEM_TAB_COLUMNS_B

Line 1142: FROM FEM_TAB_COLUMNS_B

1138:
1139:
1140: CURSOR ColumnList IS
1141: SELECT COLUMN_NAME
1142: FROM FEM_TAB_COLUMNS_B
1143: WHERE TABLE_NAME = 'FEM_BALANCES'
1144: AND FEM_DATA_TYPE_CODE = 'DIMENSION'
1145: AND DIMENSION_ID = FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id;
1146:

Line 1864: FROM FEM_TAB_COLUMNS_B

1860: --start bug fix 5560443
1861: /*
1862: CURSOR ColumnList IS
1863: SELECT COLUMN_NAME
1864: FROM FEM_TAB_COLUMNS_B
1865: WHERE TABLE_NAME = 'FEM_BALANCES'
1866: AND FEM_DATA_TYPE_CODE = 'DIMENSION'
1867: AND DIMENSION_ID = FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id;
1868: */

Line 2172: fem_tab_columns_b ftcb

2168: FROM fem_intg_dim_rules idr,
2169: fem_object_definition_b fodb,
2170: fem_xdim_dimensions fxd,
2171: fem_intg_dim_rule_defs defs,
2172: fem_tab_columns_b ftcb
2173: WHERE ftcb.table_name = 'FEM_BALANCES'
2174: AND ftcb.fem_data_type_code = 'DIMENSION'
2175: AND ftcb.dimension_id = fxd.dimension_id
2176: AND DECODE(ftcb.column_name,'INTERCOMPANY_ID', 0, fxd.dimension_id) = idr.dimension_id

Line 2403: FROM FEM_TAB_COLUMNS_B

2399: FEM_INTG_DIM_RULE_attr_err EXCEPTION;
2400:
2401: CURSOR ColumnList IS
2402: SELECT COLUMN_NAME
2403: FROM FEM_TAB_COLUMNS_B
2404: WHERE TABLE_NAME = 'FEM_BALANCES'
2405: AND FEM_DATA_TYPE_CODE = 'DIMENSION'
2406: AND DIMENSION_ID = FEM_INTG_DIM_RULE_ENG_PKG.pv_dim_id;
2407:

Line 4095: fem_tab_columns_b ftcb

4091: FROM fem_intg_dim_rules idr,
4092: fem_object_definition_b fodb,
4093: fem_xdim_dimensions fxd,
4094: fem_intg_dim_rule_defs defs,
4095: fem_tab_columns_b ftcb
4096: WHERE ftcb.table_name = 'FEM_BALANCES'
4097: AND ftcb.fem_data_type_code = 'DIMENSION'
4098: AND ftcb.dimension_id = fxd.dimension_id
4099: AND DECODE(ftcb.column_name,'INTERCOMPANY_ID', 0, fxd.dimension_id) = idr.dimension_id

Line 4630: fem_tab_columns_b ftcb

4626: FROM fem_intg_dim_rules idr,
4627: fem_object_definition_b fodb,
4628: fem_xdim_dimensions fxd,
4629: fem_intg_dim_rule_defs defs,
4630: fem_tab_columns_b ftcb
4631: WHERE ftcb.table_name = 'FEM_BALANCES'
4632: AND ftcb.fem_data_type_code = 'DIMENSION'
4633: AND ftcb.dimension_id = fxd.dimension_id
4634: AND DECODE(ftcb.column_name,'INTERCOMPANY_ID', 0, fxd.dimension_id) = idr.dimension_id