DBA Data[Home] [Help]

APPS.FEM_SOURCE_DATA_LOADER_PKG dependencies on FEM_TABLE_CLASS_ASSIGNMT_V

Line 107: l_table_name FEM_TABLE_CLASS_ASSIGNMT_V.table_name%TYPE;

103: l_dataset_code NUMBER;
104: l_source_system_code NUMBER;
105:
106: l_object_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
107: l_table_name FEM_TABLE_CLASS_ASSIGNMT_V.table_name%TYPE;
108: l_ledger_dc FEM_LEDGERS_B.ledger_display_code%TYPE;
109: l_calp_dim_grp_dc FEM_DIMENSION_GRPS_B.dimension_group_display_code%TYPE;
110: l_cal_per_end_date FEM_CAL_PERIODS_ATTR.date_assign_value%TYPE;
111: l_cal_per_number FEM_CAL_PERIODS_ATTR.number_assign_value%TYPE;

Line 3327: fem_table_class_assignmt_v t

3323: SELECT o.object_id, t.table_name
3324: INTO x_object_id, x_table_name
3325: FROM fem_object_definition_b od, fem_object_catalog_b o,
3326: fem_user_folders f, fem_data_loader_objects d,
3327: fem_table_class_assignmt_v t
3328: WHERE od.object_definition_id = p_obj_def_id
3329: AND od.object_id = o.object_id
3330: AND o.object_type_code = 'SOURCE_DATA_LOADER'
3331: AND o.folder_id = f.folder_id

Line 3488: FROM fem_table_class_assignmt_v

3484: END IF;
3485:
3486: SELECT COUNT(*)
3487: INTO l_count
3488: FROM fem_table_class_assignmt_v
3489: WHERE table_name = p_table_name
3490: AND table_classification_code = p_table_classification;
3491:
3492: IF G_LOG_LEVEL_STATEMENT >= g_log_current_level THEN