[Home] [Help]
11:
12: CURSOR c_parent_entity(p_child_entity_id NUMBER, p_hierarchy_id NUMBER, p_end_date DATE, p_cal_period_id NUMBER) IS
13:
14: SELECT gcr.parent_entity_id
15: FROM gcs_cons_relationships gcr, gcs_cons_eng_runs gcer
16: WHERE gcr.hierarchy_id = p_hierarchy_id
17: AND gcr.child_entity_id = p_child_entity_id
18: AND gcr.dominant_parent_flag = 'Y'
19: AND gcr.hierarchy_id = gcer.hierarchy_id
376: gcr.cons_relationship_id,
377: gcr.curr_treatment_id,
378: gcr.treatment_id,
379: gcr.ownership_percent
380: FROM gcs_cons_relationships gcr
381: WHERE gcr.cons_relationship_id IN
382: (p_post_cons_relationship_id, p_pre_cons_relationship_id);
383:
384: BEGIN
486: SET gat.enabled_flag = 'N', gat.hidden_flag = 'N'
487: WHERE gat.transaction_date >= l_trx_date
488: AND (EXISTS
489: (SELECT 'X'
490: FROM gcs_cons_relationships pre
491: WHERE pre.hierarchy_id = l_hierarchy_id
492: AND pre.cons_relationship_id = gat.pre_cons_relationship_id
493: AND pre.parent_entity_id = l_parent_entity_id
494: AND pre.child_entity_id = l_child_entity_id) OR EXISTS
492: AND pre.cons_relationship_id = gat.pre_cons_relationship_id
493: AND pre.parent_entity_id = l_parent_entity_id
494: AND pre.child_entity_id = l_child_entity_id) OR EXISTS
495: (SELECT 'X'
496: FROM gcs_cons_relationships post
497: WHERE post.hierarchy_id = l_hierarchy_id
498: AND post.cons_relationship_id = gat.post_cons_relationship_id
499: AND post.parent_entity_id = l_parent_entity_id
500: AND post.child_entity_id = l_child_entity_id));
788: gcer.run_entity_id,
789: gcer.hierarchy_id,
790: gcr.cons_relationship_id
791: FROM gcs_cons_eng_runs gcer,
792: gcs_cons_relationships gcr,
793: fem_cal_periods_attr fcpa,
794: gcs_entity_cons_attrs geca,
795: gcs_cal_period_maps_gt gcpmt,
796: fem_cal_periods_b fcpb,
1038: END IF;
1039:
1040: SELECT parent_entity_id
1041: INTO l_cons_entity_id
1042: FROM gcs_cons_relationships
1043: WHERE hierarchy_id = l_hierarchy_id
1044: AND child_entity_id = l_entity_id
1045: AND dominant_parent_flag = 'Y'
1046: AND l_start_cp_end_date BETWEEN start_date AND
1211: .version_id;
1212:
1213: SELECT parent_entity_id
1214: INTO l_cons_entity_id
1215: FROM gcs_cons_relationships
1216: WHERE hierarchy_id = l_hierarchy_id
1217: AND child_entity_id = l_entity_id
1218: AND dominant_parent_flag = 'Y'
1219: AND l_start_cp_end_date BETWEEN start_date AND
1305: gcs_cons_eng_run_dtls gcerd,
1306: gcs_curr_treatments_b gctb,
1307: fem_cal_periods_b fcpb,
1308: fem_cal_periods_attr fcpa_end,
1309: gcs_cons_relationships gcr,
1310: gcs_entity_cons_attrs geca_parent,
1311: gcs_entity_cons_attrs geca_child
1312: WHERE gcer.cal_period_id = fcpb.cal_period_id
1313: AND fcpb.cal_period_id = fcpa_end.cal_period_id
1557: IF (l_run_parent_entity_id = -1) THEN
1558: BEGIN
1559: SELECT parent_entity_id
1560: INTO l_parent_entity_id
1561: FROM gcs_cons_relationships
1562: WHERE hierarchy_id = p_hierarchy_id
1563: AND child_entity_id = p_run_entity_id
1564: AND dominant_parent_flag = 'Y'
1565: AND p_cal_period_end_date BETWEEN start_date AND
1706: -- Bugfix 5843592, Get the correct source ledger Id, depending upon the calendar period
1707:
1708: CURSOR c_impacted_entities(p_hierarchy_id NUMBER, p_cal_period_id NUMBER, p_cal_period_end_date DATE) IS
1709: SELECT gcr.parent_entity_id, gcr.child_entity_id, gcer.run_name
1710: FROM gcs_cons_relationships gcr,
1711: gcs_cons_eng_runs gcer,
1712: fem_global_vs_combo_defs fgvcd,
1713: gcs_entities_attr gea,
1714: fem_ledgers_attr fla
1916: .version_id;
1917:
1918: SELECT parent_entity_id
1919: INTO l_cons_entity_id
1920: FROM gcs_cons_relationships
1921: WHERE hierarchy_id = l_hierarchy_id
1922: AND child_entity_id = l_entity_id
1923: AND dominant_parent_flag = 'Y'
1924: AND l_start_cp_end_date BETWEEN start_date AND