[Home] [Help]
116: END IF;
117: CLOSE c_ca;
118: -- Check whether > maximum submission date
119: IF v_min_sub_dt IS NULL THEN
120: v_min_sub_dt := NVL(IGS_RE_GEN_001.RESP_CLC_MIN_SBMSN(
121: p_person_id,
122: p_ca_sequence_number,
123: NULL,
124: NULL,
137: END IF;
138: END IF;
139: -- Check whether > maximum submission date
140: IF v_max_sub_dt IS NULL THEN
141: v_max_sub_dt := NVL(IGS_RE_GEN_001.RESP_CLC_MAX_SBMSN(
142: p_person_id,
143: p_ca_sequence_number,
144: NULL,
145: NULL,