[Home] [Help]
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'
62: AND gcr.child_entity_id = fea.entity_id
81: gcs_cons_relationships gcr,
82: gcs_cal_period_maps_gt gcpmt,
83: fem_ledgers_attr fla,
84: gcs_entity_cons_attrs geca,
85: gcs_entities_attr gea
86: WHERE gcr.child_entity_id = gdsd.entity_id
87: AND p_cal_period_id = gcpmt.target_cal_period_id
88: AND gdsd.cal_period_id = gcpmt.source_cal_period_id
89: AND gdsd.balance_type_code = p_balance_type_code
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,
502: gcs_hierarchies_b ghb,
503: fem_cal_periods_b fcpb,
504: fem_ledgers_attr fla,
505: gcs_entity_cons_attrs geca,
506: gcs_entities_attr gea,
507: fem_cal_periods_attr fcpa_curr
508: WHERE gdsd.cal_period_id = gcpmt.source_cal_period_id
509: AND fcpb.cal_period_id = fcpa.cal_period_id
510: AND fcpb.cal_period_id = gcpmt.target_cal_period_id