APPS.IGS_AS_VAL_VEA dependencies on IGS_GE_DATE

Line 148: NVL(IGS_GR_VENUE_ADDR.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))

144: v_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
145: v_p_end_dt IGS_GR_VENUE_ADDR.end_dt%TYPE;
146: CURSOR c_va IS
147: SELECT IGS_GR_VENUE_ADDR.start_dt,
148: NVL(IGS_GR_VENUE_ADDR.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
149: FROM IGS_GR_VENUE_ADDR
150: WHERE venue_cd = p_venue_cd AND
151: addr_type = p_addr_type AND
152: start_dt <> p_start_dt;

Line 157: v_p_end_dt := NVL(p_end_dt,IGS_GE_DATE.IGSDATE('YYYY/MM/DD'));

153: BEGIN
154: p_message_name := null;
155: -- set p_end_dt to a high date if null
156:
157: v_p_end_dt := NVL(p_end_dt,IGS_GE_DATE.IGSDATE('YYYY/MM/DD'));
158: -- v_p_end_dt := NVL(p_end_dt, TO_DATE('01/01/9999','DD/MM/YYYY'));
159: OPEN c_va;
160: -- Validation will fail if any of the following are true
161: LOOP