DBA Data[Home] [Help]

APPS.GCS_DATASUB_WF_PKG dependencies on FEM_CCTR_ORGS_HIER

Line 642: fem_cctr_orgs_hier fcoh,

638: INTO l_company_value_low,
639: l_company_value_high
640: FROM fem_companies_b fcmin,
641: fem_companies_b fcmax,
642: fem_cctr_orgs_hier fcoh,
643: fem_cctr_orgs_attr fcoa
644: WHERE fcoh.hierarchy_obj_def_id = l_hier_obj_definition_id
645: AND fcoh.parent_value_set_id = l_fch_org_vs_id
646: AND fcoh.child_value_set_id = l_org_vs_id

Line 2834: fem_cctr_orgs_hier fcoh,

2830:
2831: SELECT DISTINCT geco.entity_id BULK COLLECT
2832: INTO l_entity_list
2833: FROM fem_companies_b f,
2834: fem_cctr_orgs_hier fcoh,
2835: fem_cctr_orgs_attr fcoa,
2836: gcs_entity_cctr_orgs geco,
2837: gcs_entities_attr gea,
2838: fem_entities_b feb,