DBA Data[Home] [Help]

APPS.GCS_DATASUB_UTILITY_PKG dependencies on FEM_GLOBAL_VS_COMBO_DEFS

Line 188: fem_global_vs_combo_defs fgvcd

184:
185: SELECT fgvcd.value_set_id
186: INTO l_line_item_vs_id
187: FROM fem_ledgers_attr fla,
188: fem_global_vs_combo_defs fgvcd
189: WHERE fla.ledger_id = p_ledger_id
190: AND fgvcd.global_vs_combo_id = fla.dim_attribute_numeric_member
191: AND fla.attribute_id = l_ledger_vs_combo_attr
192: AND fla.version_id = l_ledger_vs_combo_version

Line 313: FROM fem_global_vs_combo_defs fgvcd,

309: fxd.member_col,
310: fdt.dimension_name
311: BULK COLLECT
312: INTO l_dim_vs_info
313: FROM fem_global_vs_combo_defs fgvcd,
314: fem_ledgers_attr fla,
315: fem_xdim_dimensions fxd,
316: fem_dimensions_tl fdt
317: WHERE gcs_utility_pkg.get_fem_dim_required(fxd.MEMBER_COL) = 'Y'