APPS.IGS_AD_GEN_002 dependencies on IGS_GE_DATE

Line 211: IGS_GE_DATE.IGSDATE('9999/12/31'),--TO_DATE('31/12/9999', 'DD/MM/YYYY'),

207: cst_rvk_srvc) AND
208: SYSDATE BETWEEN pee.pee_start_dt AND
209: DECODE (pee.expiry_dt,
210: NULL,
211: IGS_GE_DATE.IGSDATE('9999/12/31'),--TO_DATE('31/12/9999', 'DD/MM/YYYY'),
212: pee.expiry_dt);
213: CURSOR c_sua IS
214: SELECT sua.person_id
215: FROM IGS_EN_SU_ATTEMPT sua

Line 1489: IF (v_birth_dt < IGS_GE_DATE.IGSDATE('1900/01/01')) THEN --TO_DATE('1/1/1900', 'DD/MM/YYYY')) THEN

1485: IF (v_birth_dt IS NULL) THEN
1486: v_birth_dt_str := ' ';
1487: END IF;
1488: -- If the birth date is before 1/1/1900 then write it as 000000
1489: IF (v_birth_dt < IGS_GE_DATE.IGSDATE('1900/01/01')) THEN --TO_DATE('1/1/1900', 'DD/MM/YYYY')) THEN
1490: v_birth_dt_str := '000000';
1491: END IF;
1492: v_space_pos := INSTR(v_given_names, ' ');
1493: IF (v_space_pos = 0) THEN