APPS.IGS_GR_VAL_GC dependencies on IGS_GR_AWD_CRMN

Line 118: -- Description: Check if any IGS_GR_AWD_CRMN records exist

114: p_message_name OUT NOCOPY VARCHAR2 )
115: RETURN BOOLEAN AS
116:
117: BEGIN -- grdp_val_gc_upd
118: -- Description: Check if any IGS_GR_AWD_CRMN records exist
119: -- for this IGS_GR_CRMN.
120: DECLARE
121: v_gac_exists VARCHAR2(1);
122: CURSOR c_gac IS

Line 124: FROM IGS_GR_AWD_CRMN gac

120: DECLARE
121: v_gac_exists VARCHAR2(1);
122: CURSOR c_gac IS
123: SELECT 'X'
124: FROM IGS_GR_AWD_CRMN gac
125: WHERE gac.grd_cal_type = p_grd_cal_type AND
126: gac.grd_ci_sequence_number = p_grd_ci_sequence_number AND
127: gac.ceremony_number = p_ceremony_number;
128: BEGIN