APPS.GCS_HIERARCHIES_PKG dependencies on GCS_TREATMENTS_B

Line 943: FROM gcs_cons_relationships r, gcs_treatments_b tb

939: decode(sign(r.end_date - p_end_date),
940: 1,
941: p_end_date,
942: r.end_date))) end_date
943: FROM gcs_cons_relationships r, gcs_treatments_b tb
944: WHERE r.hierarchy_id = p_hierarchy_id
945: AND r.child_entity_id = p_original_entity_id
946: AND r.actual_ownership_flag = 'Y'
947: AND r.start_date <= nvl(r.end_date, r.start_date)

Line 973: FROM gcs_cons_relationships r, gcs_treatments_b tb

969: decode(sign(r.end_date - p_end_date),
970: 1,
971: p_end_date,
972: r.end_date))) end_date
973: FROM gcs_cons_relationships r, gcs_treatments_b tb
974: WHERE r.hierarchy_id = p_hierarchy_id
975: AND r.child_entity_id = p_parent_entity_id
976: AND r.actual_ownership_flag = 'Y'
977: AND r.start_date <= nvl(r.end_date, r.start_date)

Line 1066: FROM gcs_cons_relationships r, gcs_treatments_b tb

1062: 1,
1063: r.start_date,
1064: p_effective_date) start_date,
1065: r.end_date
1066: FROM gcs_cons_relationships r, gcs_treatments_b tb
1067: WHERE r.hierarchy_id = p_hierarchy_id
1068: AND r.child_entity_id = p_child_entity_id
1069: AND r.actual_ownership_flag = 'Y'
1070: AND r.start_date <= nvl(r.end_date, r.start_date)

Line 1352: FROM gcs_cons_relationships r, gcs_treatments_b tb

1348: AND r.actual_ownership_flag = 'Y'
1349: AND r.dominant_parent_flag = 'Y';
1350: CURSOR future_full_c IS
1351: SELECT r.*
1352: FROM gcs_cons_relationships r, gcs_treatments_b tb
1353: WHERE r.hierarchy_id = l_hierarchy_id
1354: AND r.child_entity_id = l_child_id
1355: AND r.parent_entity_id <> l_parent_id
1356: AND r.start_date <= nvl(r.end_date, r.start_date)

Line 1364: FROM gcs_cons_relationships r, gcs_treatments_b tb

1360: AND tb.consolidation_type_code = 'FULL'
1361: ORDER BY r.start_date;
1362: CURSOR non_full_dominant_straddle_c IS
1363: SELECT r.cons_relationship_id
1364: FROM gcs_cons_relationships r, gcs_treatments_b tb
1365: WHERE r.hierarchy_id = l_hierarchy_id
1366: AND r.child_entity_id = l_child_id
1367: AND r.parent_entity_id <> l_parent_id
1368: AND r.start_date <= nvl(r.end_date, r.start_date)

Line 1418: FROM gcs_cons_relationships r, gcs_treatments_b tb

1414: l_treat_id,
1415: l_ccy_treat_id,
1416: l_dominant_flag,
1417: l_treat_type
1418: FROM gcs_cons_relationships r, gcs_treatments_b tb
1419: WHERE r.cons_relationship_id = p_rel_id
1420: AND tb.treatment_id = r.treatment_id;
1421: IF l_treat_type = 'FULL' THEN
1422: UPDATE gcs_cons_relationships r

Line 1630: FROM gcs_treatments_b tb

1626: AND r.actual_ownership_flag = 'Y'
1627: AND r.dominant_parent_flag = 'Y'
1628: AND EXISTS
1629: (SELECT 1
1630: FROM gcs_treatments_b tb
1631: WHERE tb.treatment_id = r.treatment_id
1632: AND tb.consolidation_type_code = 'NONE');
1633: ELSE
1634: -- dominant flag = 'N'