636: SELECT min(fcmin.company_display_code),
637: min(fcmax.company_display_code)
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
637: min(fcmax.company_display_code)
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
661: SELECT min(fcmin.company_display_code),
662: min(fcmax.company_display_code)
663: INTO l_company_value_low,
664: l_company_value_high
665: FROM fem_companies_b fcmin,
666: fem_companies_b fcmax,
667: gcs_entity_organizations geo
668: WHERE geo.entity_id = p_datasub_info.entity_id
669: AND geo.company_cost_center_org_id = fcmin.company_id
662: min(fcmax.company_display_code)
663: INTO l_company_value_low,
664: l_company_value_high
665: FROM fem_companies_b fcmin,
666: fem_companies_b fcmax,
667: gcs_entity_organizations geo
668: WHERE geo.entity_id = p_datasub_info.entity_id
669: AND geo.company_cost_center_org_id = fcmin.company_id
670: AND geo.company_cost_center_org_id = fcmax.company_id;
2829: -- Bugfix 5843592
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,
2869: END IF;
2870:
2871: SELECT DISTINCT geo.entity_id BULK COLLECT
2872: INTO l_entity_list
2873: FROM fem_companies_b fcb,
2874: gcs_entity_organizations geo,
2875: gcs_entities_attr gea,
2876: fem_entities_b feb
2877: WHERE feb.entity_id = gea.entity_id