DBA Data[Home] [Help]

APPS.GCS_DATASUB_WF_PKG dependencies on FEM_CCTR_ORGS_ATTR

Line 643: fem_cctr_orgs_attr fcoa

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
647: AND fcoh.child_id = fcoa.company_cost_center_org_id

Line 2835: fem_cctr_orgs_attr fcoa,

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,
2839: fem_cal_periods_attr fcpa