APPS.IGF_AP_OSS_INTEGR dependencies on IGS_PE_EIT_RESTATUS_V

Line 199: SELECT * FROM igs_pe_eit_restatus_v

195: (reverse chronological order - newest change first)
196: ***************************************************************/
197:
198: CURSOR c_get_citizen_stat IS
199: SELECT * FROM igs_pe_eit_restatus_v
200: WHERE person_id = p_person_id
201: AND (
202: (TRUNC(SYSDATE) BETWEEN TRUNC(start_date) AND TRUNC(end_date))
203: OR (start_date IS NULL) OR (end_date IS NULL)