APPS.IGS_GR_VAL_GR dependencies on IGS_GR_CRMN

Line 989: FROM IGS_GR_CRMN gc

985: SELECT gc.ceremony_dt_alias,
986: gc.ceremony_dai_sequence_number,
987: gc.closing_dt_alias,
988: gc.closing_dai_sequence_number
989: FROM IGS_GR_CRMN gc
990: WHERE gc.grd_cal_type = cp_grd_cal_type AND
991: gc.grd_ci_sequence_number = cp_grd_ci_sequence_number AND
992: gc.ceremony_number = cp_ceremony_number;
993: v_gc_rec c_gc%ROWTYPE;

Line 1066: FROM IGS_GR_CRMN_ROUND crd

1062: SELECT crd.start_dt_alias,
1063: crd.start_dai_sequence_number,
1064: crd.end_dt_alias,
1065: crd.end_dai_sequence_number
1066: FROM IGS_GR_CRMN_ROUND crd
1067: WHERE crd.grd_cal_type = p_grd_cal_type AND
1068: crd.grd_ci_sequence_number = p_grd_ci_sequence_number;
1069: v_crd_rec c_crd%ROWTYPE;
1070: v_start_dt DATE DEFAULT NULL;