APPS.IGS_AD_VAL_AA dependencies on IGS_GE_DATE

Line 898: NVL(api.end_dt, IGS_GE_DATE.IGSCHAR('9999/01/01')) >= p_appl_dt) AND

894: IGS_PE_PERSON_ID_TYP pit
895: WHERE api.pe_person_id = p_person_id AND
896: (api.start_dt IS NULL OR
897: (api.start_dt <= p_appl_dt AND
898: NVL(api.end_dt, IGS_GE_DATE.IGSCHAR('9999/01/01')) >= p_appl_dt) AND
899: (api.end_dt IS NULL OR api.start_dt <> api.end_dt)) AND
900: pit.person_id_type = api.person_id_type AND
901: pit.s_person_id_type = 'TAC';
902: BEGIN