APPS.GCS_INTERCO_PROCESSING_PKG dependencies on GCS_INTERCO_MEMBERS

Line 1184: GCS_INTERCO_MEMBERS gim,

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 ,
1186: FND_CURRENCIES fc
1187: WHERE giet.hierarchy_id = p_hierarchy_id
1188: AND giet.cal_period_id = p_cal_period_id

Line 1205: gcs_interco_members gim1

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 =
1209: giet.target_entity_id

Line 1317: GCS_INTERCO_MEMBERS gim,

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 ,
1319: FND_CURRENCIES fc
1320: WHERE giet.hierarchy_id = p_hierarchy_id
1321: AND giet.cal_period_id = p_cal_period_id

Line 1339: GCS_INTERCO_MEMBERS gim1

1335: AND gib.enabled_flag = 'Y'
1336: AND NOT EXISTS
1337: (SELECT 'Y'
1338: FROM GCS_INTERCO_HDR_GT gihg1,
1339: GCS_INTERCO_MEMBERS gim1
1340: WHERE gihg1.target_entity_id =
1341: DECODE(gim1.line_item_id,
1342: gim.line_item_id,
1343: giet.target_entity_id,

Line 1478: GCS_INTERCO_MEMBERS gim,

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
1482: AND giet.cal_period_id = p_cal_period_id