APPS.IGS_AS_VAL_GS dependencies on IGS_GE_DATE

Line 70: NVL(end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))

66: BEGIN
67: DECLARE
68: CURSOR c_gs IS
69: SELECT start_dt,
70: NVL(end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'))
71: FROM IGS_AS_GRD_SCHEMA
72: WHERE grading_schema_cd = p_grading_schema_cd AND
73: version_number <> p_version_number;
74: v_gs_rec c_gs%ROWTYPE;

Line 82: v_p_end_dt := NVL(p_end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'));

78: v_p_end_dt IGS_AS_GRD_SCHEMA.end_dt%TYPE;
79: BEGIN
80: p_message_name := null;
81: -- set p_end_dt to a high date if null
82: v_p_end_dt := NVL(p_end_dt, IGS_GE_DATE.IGSDATE('9999/01/01'));
83: OPEN c_gs;
84: -- Validation will fail if any of the following are true
85: LOOP
86: EXIT WHEN (c_gs%NOTFOUND);