APPS.GCS_INTERCO_PROCESSING_PKG dependencies on GCS_INTERCO_ELM_TRX

Line 448: -- eliminations from GCS_INTERCO_ELM_TRX (dataprep temp table)

444: END IF;
445:
446: -- calling routine to insert intercompany elimination lines.
447: -- This routine inserts all eligible intercompany/intracompany
448: -- eliminations from GCS_INTERCO_ELM_TRX (dataprep temp table)
449: -- into GCS_ENTRY_LINES.
450:
451: --dbms_output.put_line ('Just before calling insert lines');
452:

Line 1181: FROM GCS_INTERCO_ELM_TRX giet,

1177: gib.sus_user_dim4_id, gib.sus_user_dim5_id,
1178: gib.sus_user_dim6_id, gib.sus_user_dim7_id,
1179: gib.sus_user_dim8_id, gib.sus_user_dim9_id,
1180: gib.sus_user_dim10_id, fc.currency_code
1181: FROM GCS_INTERCO_ELM_TRX giet,
1182: GCS_FLATTENED_RELNS gfr,
1183: GCS_FLATTENED_RELNS gfr1,
1184: GCS_INTERCO_MEMBERS gim,
1185: GCS_INTERCO_RULES_B gib ,

Line 1204: (SELECT 'X' FROM gcs_interco_elm_trx giet1,

1200: AND gim.line_item_group = 1
1201: AND gim.rule_id = gib.rule_id
1202: AND gib.enabled_flag = 'Y'
1203: AND NOT EXISTS
1204: (SELECT 'X' FROM gcs_interco_elm_trx giet1,
1205: gcs_interco_members gim1
1206: WHERE giet1.hierarchy_id = p_hierarchy_id
1207: AND giet1.cal_period_id = p_cal_period_id
1208: AND giet1.src_entity_id =

Line 1314: FROM GCS_INTERCO_ELM_TRX giet,

1310: gib.sus_user_dim4_id, gib.sus_user_dim5_id,
1311: gib.sus_user_dim6_id, gib.sus_user_dim7_id,
1312: gib.sus_user_dim8_id, gib.sus_user_dim9_id,
1313: gib.sus_user_dim10_id, fc.currency_code
1314: FROM GCS_INTERCO_ELM_TRX giet,
1315: GCS_FLATTENED_RELNS gfr,
1316: GCS_FLATTENED_RELNS gfr1,
1317: GCS_INTERCO_MEMBERS gim,
1318: GCS_INTERCO_RULES_B gib ,

Line 1477: FROM GCS_INTERCO_ELM_TRX giet,

1473: gib.sus_user_dim4_id, gib.sus_user_dim5_id,
1474: gib.sus_user_dim6_id, gib.sus_user_dim7_id,
1475: gib.sus_user_dim8_id, gib.sus_user_dim9_id,
1476: gib.sus_user_dim10_id, fc.currency_code
1477: FROM GCS_INTERCO_ELM_TRX giet,
1478: GCS_INTERCO_MEMBERS gim,
1479: GCS_INTERCO_RULES_B gib,
1480: FND_CURRENCIES fc
1481: WHERE giet.hierarchy_id = p_hierarchy_id