DBA Data[Home] [Help]

APPS.GCS_IMPACT_WRITER_PKG dependencies on FEM_CCTR_ORGS_ATTR

Line 274: -- use fem_cctr_orgs_attr to get the company id values for each organization

270: l_fch_gvcd_value_set_id,
271: l_ledger_period_bsv_info(l_ledger_period_bsv_index).ledger_gvcd_value_set_id,
272: l_her_obj_def_id )
273: LOOP
274: -- use fem_cctr_orgs_attr to get the company id values for each organization
275: SELECT dim_attribute_numeric_member
276: INTO l_company_id
277: FROM fem_cctr_orgs_attr fda
278: WHERE fda.company_cost_center_org_id = rec_list_of_orgs.company_cost_center_org_id

Line 277: FROM fem_cctr_orgs_attr fda

273: LOOP
274: -- use fem_cctr_orgs_attr to get the company id values for each organization
275: SELECT dim_attribute_numeric_member
276: INTO l_company_id
277: FROM fem_cctr_orgs_attr fda
278: WHERE fda.company_cost_center_org_id = rec_list_of_orgs.company_cost_center_org_id
279: AND fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').attribute_id
280: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id;
281: