APPS.GCS_DATASUB_WF_PKG dependencies on FEM_LEDGERS_ATTR

Line 205: fem_ledgers_attr fla

201: BEGIN
202: SELECT 'I'
203: INTO l_execution_mode
204: FROM fem_data_locations fdl,
205: fem_ledgers_attr fla
206: WHERE fdl.ledger_id = p_datasub_info.ledger_id
207: AND fdl.cal_period_id = p_datasub_info.cal_period_id
208: AND fdl.dataset_code = p_datasub_info.dataset_code
209: AND fdl.source_system_code = p_datasub_info.source_system_code

Line 587: FROM fem_ledgers_attr fla,

583: fgvcd_local_org.value_set_id
584: INTO l_global_vs_combo_id,
585: l_company_vs_id,
586: l_org_vs_id
587: FROM fem_ledgers_attr fla,
588: fem_global_vs_combo_defs fgvcd_local_company,
589: fem_global_vs_combo_defs fgvcd_local_org
590: WHERE fla.ledger_id = p_datasub_info.ledger_id
591: AND fla.attribute_id = l_global_vs_combo_attr

Line 1772: FROM fem_ledgers_attr fla

1768: --Bugfix 4969879: Remove call to get_reference_data_info
1769:
1770: SELECT fla.dim_attribute_varchar_member
1771: INTO l_func_crncy_code
1772: FROM fem_ledgers_attr fla
1773: WHERE fla.ledger_id = l_datasub_info.ledger_id
1774: AND fla.attribute_id = g_ledger_curr_attr
1775: AND fla.version_id = g_ledger_curr_version;
1776:

Line 2035: fem_ledgers_attr fla

2031: BEGIN
2032: SELECT 'I'
2033: INTO l_load_method_code
2034: FROM fem_data_locations fdl,
2035: fem_ledgers_attr fla
2036: WHERE fdl.ledger_id = l_datasub_info.ledger_id
2037: AND fdl.cal_period_id = l_datasub_info.cal_period_id
2038: AND fdl.dataset_code = l_datasub_info.dataset_code
2039: AND fdl.source_system_code = l_datasub_info.source_system_code

Line 2058: FROM fem_ledgers_attr fla,

2054: END IF;
2055:
2056: SELECT fgvcd.value_set_id
2057: INTO l_line_item_vs_id
2058: FROM fem_ledgers_attr fla,
2059: fem_global_vs_combo_defs fgvcd
2060: WHERE fla.ledger_id = l_datasub_info.ledger_id
2061: AND fgvcd.global_vs_combo_id = fla.dim_attribute_numeric_member
2062: AND fla.attribute_id = g_ledger_vs_combo_attr

Line 2765: FROM fem_ledgers_attr fla,

2761: fgvcd_local_org.value_set_id
2762: INTO l_global_vs_combo_id,
2763: l_company_vs_id,
2764: l_org_vs_id
2765: FROM fem_ledgers_attr fla,
2766: fem_global_vs_combo_defs fgvcd_local_company,
2767: fem_global_vs_combo_defs fgvcd_local_org
2768: WHERE fla.ledger_id = l_ledger_id
2769: AND fla.attribute_id = l_global_vs_combo_attr