DBA Data[Home] [Help]

APPS.GCS_IMPACT_WRITER_PKG dependencies on GCS_ENTITY_CCTR_ORGS

Line 84: FROM gcs_entity_cctr_orgs

80: p_ledger_gvcd_value_set_id NUMBER,
81: p_her_obj_def_id NUMBER)
82: IS
83: SELECT company_cost_center_org_id
84: FROM gcs_entity_cctr_orgs
85: WHERE entity_id = EntityId
86: AND 1 = p_orgs_flag_param
87:
88: UNION

Line 96: FROM gcs_entity_cctr_orgs

92: WHERE 2 = p_orgs_flag_param
93: AND parent_value_set_id = p_fch_vsid
94: AND child_value_set_id = p_ledger_gvcd_value_set_id
95: AND parent_id IN ( SELECT company_cost_center_org_id
96: FROM gcs_entity_cctr_orgs
97: WHERE entity_id = EntityId )
98: AND hierarchy_obj_def_id = p_her_obj_def_id ;
99:
100: CURSOR c_check_bal_seg_val ( p_comp_display_code VARCHAR2,

Line 240: --gcs_entity_cctr_orgs to get the list of Organization values for this entity

236: row_inner_rec.actual_flag)
237: LOOP
238:
239: --this will be in the FCH GVSC's org value set
240: --gcs_entity_cctr_orgs to get the list of Organization values for this entity
241: IF (l_ledger_period_bsv_info(l_ledger_period_bsv_index).map_flag = 'MAPPED') THEN
242: l_orgs_flag_param := 1;
243: l_her_obj_def_id := -1;
244: