313:
314: -- Used to get the specific intercompany information
315: CURSOR category_c IS
316: SELECT specific_intercompany_id
317: FROM gcs_categories_b
318: WHERE category_code = 'INTRACOMPANY';
319:
320: -- Used to determine if translation is being run for the first time for
321: -- this relationship and dataset.
388: c_ledger_id NUMBER,
389: c_entity_id NUMBER) IS
390: SELECT 1
391: FROM fem_balances fb,
392: gcs_categories_b cb
393: WHERE fb.dataset_code = p_hier_dataset_code
394: AND fb.cal_period_id = c_cal_period_id
395: AND fb.source_system_code = c_source_system_code
396: AND fb.currency_code = c_currency_code
481:
482:
483: write_to_log(module, FND_LOG.LEVEL_STATEMENT,
484: 'SELECT specific_intercompany_id' || g_nl||
485: 'FROM gcs_categories_b' || g_nl ||
486: 'WHERE category_code = ''INTRACOMPANY''');
487:
488: -- Get the intercompany information
489: OPEN category_c;
1288:
1289: -- Get the object id for TRANSLATION
1290: CURSOR get_object_id IS
1291: SELECT cb.associated_object_id
1292: FROM gcs_categories_b cb
1293: WHERE cb.category_code = 'TRANSLATION';
1294:
1295: fb_object_id NUMBER;
1296: