DBA Data[Home] [Help]

APPS.GCS_DATASUB_WF_PKG dependencies on GCS_ENTITY_ORGANIZATIONS

Line 667: gcs_entity_organizations geo

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;
671: END IF;

Line 2874: gcs_entity_organizations geo,

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
2878: AND geo.entity_id = gea.entity_id