DBA Data[Home] [Help]

APPS.GCS_DP_DYNAMIC_PKG dependencies on FEM_LEDGERS_ATTR

Line 73: FROM fem_ledgers_attr fla,

69: fnd_log.STRING (fnd_log.level_statement,
70: g_pkg_name || '.' || l_api_name,
71: ' SELECT fla.dim_attribute_numeric_member
72: INTO l_source_global_vs_combo
73: FROM fem_ledgers_attr fla,
74: fem_dim_attributes_b fdab,
75: fem_dim_attr_versions_b fdavb
76: WHERE fla.ledger_id = ' || p_source_ledger_id || '
77: AND fla.attribute_id = fdab.attribute_id

Line 85: FROM fem_ledgers_attr fla,

81: AND fdavb.default_version_flag = ''Y'' ');
82: END IF;
83: SELECT fla.dim_attribute_numeric_member
84: INTO l_source_global_vs_combo
85: FROM fem_ledgers_attr fla,
86: fem_dim_attributes_b fdab,
87: fem_dim_attr_versions_b fdavb
88: WHERE fla.ledger_id = p_source_ledger_id
89: AND fla.attribute_id = fdab.attribute_id

Line 422: fem_ledgers_attr fla,

418: FND_GLOBAL.USER_ID,
419: FND_GLOBAL.LOGIN_ID ';
420: l_from_text := '
421: FROM fem_balances fb,
422: fem_ledgers_attr fla,
423: gcs_entity_cctr_orgs geco,
424: gcs_cons_impact_analyses gcia,
425: gcs_data_sub_dtls gdsd '|| l_from_text;
426: l_where_text :=

Line 1622: fem_ledgers_attr fla,

1618: SYSDATE,
1619: FND_GLOBAL.USER_ID,
1620: FND_GLOBAL.LOGIN_ID
1621: FROM fem_balances fb,
1622: fem_ledgers_attr fla,
1623: gcs_entity_cctr_orgs geco,
1624: gcs_cons_impact_analyses gcia,
1625: gcs_data_sub_dtls gdsd
1626: WHERE fb.ledger_id = p_source_ledger_id

Line 1670: fem_ledgers_attr fla,

1666: SYSDATE,
1667: FND_GLOBAL.USER_ID,
1668: FND_GLOBAL.LOGIN_ID
1669: FROM fem_balances fb,
1670: fem_ledgers_attr fla,
1671: gcs_entity_cctr_orgs geco,
1672: gcs_cons_impact_analyses gcia,
1673: gcs_data_sub_dtls gdsd
1674: WHERE fb.ledger_id = p_source_ledger_id