APPS.GCS_DATA_PREP_PKG dependencies on GCS_CONS_RELATIONSHIPS

Line 1027: FROM gcs_cons_relationships gcr,

1023: fnd_log.STRING(fnd_log.level_statement,
1024: g_pkg_name || '.' || l_api_name,
1025: 'SELECT nvl(ownership_percent, 100) * 0.01
1026: INTO l_owner_percentage
1027: FROM gcs_cons_relationships gcr,
1028: gcs_treatments_b gtb
1029: WHERE cons_relationship_id =' ||
1030: p_cons_rel_id || '
1031: AND gcr.treatment_id = gtb.treatment_id' || '

Line 1037: FROM gcs_cons_relationships gcr, gcs_treatments_b gtb

1033: END IF;
1034:
1035: SELECT NVL(ownership_percent, 100) * 0.01
1036: INTO l_owner_percentage
1037: FROM gcs_cons_relationships gcr, gcs_treatments_b gtb
1038: WHERE cons_relationship_id = p_cons_rel_id
1039: AND gcr.treatment_id = gtb.treatment_id
1040: AND gtb.consolidation_type_code = 'PARTIAL';
1041: EXCEPTION

Line 3353: FROM gcs_cons_relationships gcr, gcs_treatments_b gtb

3349: cursor c_cons_rel_data IS
3350: SELECT gcr.child_entity_id,
3351: gcr.hierarchy_id,
3352: nvl(ownership_percent, 100) * 0.01 ownership_percent
3353: FROM gcs_cons_relationships gcr, gcs_treatments_b gtb
3354: WHERE cons_relationship_id = p_cons_relationship_id
3355: AND gcr.treatment_id = gtb.treatment_id(+)
3356: AND gtb.consolidation_type_code(+) = 'PARTIAL';
3357: l_target_cal_period_id NUMBER;