134: END IF;
135:
136: SELECT gea.ledger_id
137: INTO l_ledger_id
138: FROM gcs_entities_attr gea,
139: fem_cal_periods_attr fcpa_end_date
140: WHERE gea.entity_id = p_entity_id
141: AND gea.data_type_code = 'ACTUAL'
142: AND fcpa_end_date.cal_period_id = to_number(p_cal_period_id_str)
224: END IF;
225:
226: SELECT gea.source_system_code
227: INTO l_src_sys_code
228: FROM gcs_entities_attr gea,
229: fem_cal_periods_attr fcpa_end_date
230: WHERE gea.entity_id = p_entity_id
231: AND gea.data_type_code = 'ACTUAL'
232: AND fcpa_end_date.cal_period_id = to_number(p_cal_period_id_str)