[Home] [Help]
53:
54: CURSOR c_child_count IS
55: SELECT count(1)
56: FROM gcs_cons_relationships gcr,
57: fem_entities_attr fea,
58: gcs_entities_attr gea
59: WHERE gcr.hierarchy_id = p_hierarchy_id
60: AND gcr.parent_entity_id = p_entity_id
61: AND gcr.dominant_parent_flag = 'Y'
76:
77: CURSOR c_op_entities IS
78: SELECT status_code
79: FROM gcs_data_sub_dtls gdsd,
80: fem_entities_attr fea,
81: gcs_cons_relationships gcr,
82: gcs_cal_period_maps_gt gcpmt,
83: fem_ledgers_attr fla,
84: gcs_entity_cons_attrs geca,
111:
112: CURSOR c_cons_entities IS
113: SELECT gcds.status_code
114: FROM gcs_cons_data_statuses gcds,
115: fem_entities_attr fea,
116: gcs_cons_relationships gcr
117: WHERE gcr.child_entity_id = gcds.consolidation_entity_id
118: AND gcds.cal_period_id = p_cal_period_id
119: AND gcds.balance_type_code = p_balance_type_code
282: FROM gcs_data_sub_dtls gdsd,
283: fem_cal_periods_attr fcpa,
284: fem_ledgers_attr fla,
285: gcs_entity_cons_attrs geca,
286: fem_entities_attr fea_cur
287: WHERE gdsd.entity_id = p_entity_id
288: AND gdsd.cal_period_id = fcpa.cal_period_id
289: AND gdsd.most_recent_flag = 'Y'
290: AND fcpa.attribute_id = g_cal_period_end_date_attr
487: l_api_name VARCHAR2(80) := 'update_data_status';
488:
489: -- bug fix 4554149
490: -- Bugfix 5843592, Get the correct source ledger Id, depending upon the calendar period
491: -- and use gcs_entities_attr instead of fem_entities_attr
492:
493: CURSOR c_load_data(p_load_id NUMBER) IS
494: SELECT DISTINCT ghb.hierarchy_id,
495: gdsd.entity_id,
541: CURSOR c_child_id(p_hierarchy_id NUMBER) IS
542: SELECT gcr.child_entity_id,
543: gcr.start_date
544: FROM gcs_cons_relationships gcr,
545: fem_entities_attr fea
546: WHERE gcr.hierarchy_id = p_hierarchy_id
547: AND gcr.dominant_parent_flag = 'Y'
548: AND gcr.child_entity_id = fea.entity_id
549: AND fea.attribute_id = g_entity_type_attr
720: CURSOR c_child_id IS
721: SELECT gcr.child_entity_id,
722: gcr.start_date
723: FROM gcs_cons_relationships gcr,
724: fem_entities_attr fea
725: WHERE gcr.hierarchy_id = p_hierarchy_id
726: AND gcr.dominant_parent_flag = 'Y'
727: AND gcr.child_entity_id = fea.entity_id
728: AND fea.attribute_id = g_entity_type_attr