DBA Data[Home] [Help]

APPS.GCS_DATA_PREP_PKG dependencies on GCS_ENTITIES_ATTR

Line 935: FROM gcs_entity_cons_attrs geca, fem_ledgers_attr fla, gcs_entities_attr gea

931: )
932: INTO l_source_ledger_id,
933: l_source_currency_code,
934: l_source_currency_type_code
935: FROM gcs_entity_cons_attrs geca, fem_ledgers_attr fla, gcs_entities_attr gea
936: WHERE geca.entity_id = ' ||
937: p_entity_id || '
938: AND geca.hierarchy_id = ' ||
939: p_hierarchy_id || '

Line 973: gcs_entities_attr gea,

969: l_source_currency_code,
970: l_source_currency_type_code
971: FROM gcs_entity_cons_attrs geca,
972: fem_ledgers_attr fla,
973: gcs_entities_attr gea,
974: fem_cal_periods_attr fcpa
975: WHERE geca.entity_id = p_entity_id
976: AND geca.hierarchy_id = p_hierarchy_id
977: AND gea.entity_id = geca.entity_id

Line 2045: FROM gcs_entities_attr gea,

2041:
2042: BEGIN
2043: SELECT gea.source_system_code
2044: INTO l_source_system_code
2045: FROM gcs_entities_attr gea,
2046: fem_cal_periods_attr fcpa
2047: WHERE gea.entity_id = p_entity_id
2048: AND gea.data_type_code = p_balance_type_code
2049: AND fcpa.cal_period_id = p_target_cal_period_id