APPS.GCS_DATASUB_WF_PKG dependencies on FEM_GLOBAL_VS_COMBO_DEFS

Line 588: fem_global_vs_combo_defs fgvcd_local_company,

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
592: AND fla.version_id = l_global_vs_combo_version

Line 589: fem_global_vs_combo_defs fgvcd_local_org

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
592: AND fla.version_id = l_global_vs_combo_version
593: AND fla.dim_attribute_numeric_member =

Line 606: FROM fem_global_vs_combo_defs fgvcd_fch_company,

602: SELECT fgvcd_fch_company.value_set_id,
603: fgvcd_fch_org.value_set_id
604: INTO l_fch_company_vs_id,
605: l_fch_org_vs_id
606: FROM fem_global_vs_combo_defs fgvcd_fch_company,
607: fem_global_vs_combo_defs fgvcd_fch_org
608: WHERE fgvcd_fch_company.global_vs_combo_id =
609: gcs_utility_pkg.g_fch_global_vs_combo_id
610: AND fgvcd_fch_org.global_vs_combo_id =

Line 607: fem_global_vs_combo_defs fgvcd_fch_org

603: fgvcd_fch_org.value_set_id
604: INTO l_fch_company_vs_id,
605: l_fch_org_vs_id
606: FROM fem_global_vs_combo_defs fgvcd_fch_company,
607: fem_global_vs_combo_defs fgvcd_fch_org
608: WHERE fgvcd_fch_company.global_vs_combo_id =
609: gcs_utility_pkg.g_fch_global_vs_combo_id
610: AND fgvcd_fch_org.global_vs_combo_id =
611: fgvcd_fch_company.global_vs_combo_id

Line 2059: fem_global_vs_combo_defs fgvcd

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
2063: AND fla.version_id = g_ledger_vs_combo_version

Line 2766: fem_global_vs_combo_defs fgvcd_local_company,

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
2770: AND fla.version_id = l_global_vs_combo_version

Line 2767: fem_global_vs_combo_defs fgvcd_local_org

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
2770: AND fla.version_id = l_global_vs_combo_version
2771: AND fla.dim_attribute_numeric_member =

Line 2782: FROM fem_global_vs_combo_defs fgvcd_fch_company,

2778: SELECT fgvcd_fch_company.value_set_id,
2779: fgvcd_fch_org.value_set_id
2780: INTO l_fch_company_vs_id,
2781: l_fch_org_vs_id
2782: FROM fem_global_vs_combo_defs fgvcd_fch_company,
2783: fem_global_vs_combo_defs fgvcd_fch_org,
2784: gcs_system_options gso
2785: WHERE fgvcd_fch_company.global_vs_combo_id =
2786: gso.fch_global_vs_combo_id

Line 2783: fem_global_vs_combo_defs fgvcd_fch_org,

2779: fgvcd_fch_org.value_set_id
2780: INTO l_fch_company_vs_id,
2781: l_fch_org_vs_id
2782: FROM fem_global_vs_combo_defs fgvcd_fch_company,
2783: fem_global_vs_combo_defs fgvcd_fch_org,
2784: gcs_system_options gso
2785: WHERE fgvcd_fch_company.global_vs_combo_id =
2786: gso.fch_global_vs_combo_id
2787: AND fgvcd_fch_org.global_vs_combo_id =