DBA Data[Home] [Help]

APPS.IGS_GR_VAL_GAC dependencies on IGS_GR_CRMN

Line 70: FROM IGS_GR_CRMN_ROUND crd

66: SELECT crd.start_dt_alias,
67: crd.start_dai_sequence_number,
68: crd.end_dt_alias,
69: crd.end_dai_sequence_number
70: FROM IGS_GR_CRMN_ROUND crd
71: WHERE crd.grd_cal_type = p_grd_cal_type AND
72: crd.grd_ci_sequence_number = p_grd_ci_sequence_number;
73: v_crd_rec c_crd%ROWTYPE;
74: CURSOR c_gc IS

Line 79: FROM IGS_GR_CRMN gc

75: SELECT gc.ceremony_dt_alias,
76: gc.ceremony_dai_sequence_number,
77: gc.closing_dt_alias,
78: gc.closing_dai_sequence_number
79: FROM IGS_GR_CRMN gc
80: WHERE gc.grd_cal_type = p_grd_cal_type AND
81: gc.grd_ci_sequence_number = p_grd_ci_sequence_number AND
82: gc.ceremony_number = p_ceremony_number;
83: v_gc_rec c_gc%ROWTYPE;