APPS.FEM_SOURCE_DATA_LOADER_PKG dependencies on FEM_CAL_PERIODS_ATTR

Line 110: l_cal_per_end_date FEM_CAL_PERIODS_ATTR.date_assign_value%TYPE;

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;
112: l_dataset_dc FEM_DATASETS_B.dataset_display_code%TYPE;
113: l_source_system_dc FEM_SOURCE_SYSTEMS_B.source_system_display_code%TYPE;
114:

Line 111: l_cal_per_number FEM_CAL_PERIODS_ATTR.number_assign_value%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;
112: l_dataset_dc FEM_DATASETS_B.dataset_display_code%TYPE;
113: l_source_system_dc FEM_SOURCE_SYSTEMS_B.source_system_display_code%TYPE;
114:
115: l_condition VARCHAR2(1000);

Line 4114: FROM fem_cal_periods_attr

4110:
4111: BEGIN
4112: SELECT date_assign_value
4113: INTO x_cal_per_end_date
4114: FROM fem_cal_periods_attr
4115: WHERE attribute_id = l_dim_attr_id
4116: AND version_id = l_dim_attr_ver_id
4117: AND cal_period_id = p_cal_period_id;
4118:

Line 4161: FROM fem_cal_periods_attr

4157:
4158: BEGIN
4159: SELECT number_assign_value
4160: INTO x_cal_per_number
4161: FROM fem_cal_periods_attr
4162: WHERE attribute_id = l_dim_attr_id
4163: AND version_id = l_dim_attr_ver_id
4164: AND cal_period_id = p_cal_period_id;
4165: