APPS.IGF_SL_CL_VALIDATION dependencies on IGS_PE_EIT_RESTATUS_V

Line 408: FROM igs_pe_eit_restatus_v pct

404: -- FA 161 - Bug # 5006583
405: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS
406: SELECT
407: pct.restatus_code
408: FROM igs_pe_eit_restatus_v pct
409: WHERE pct.person_id = cp_person_id AND
410: SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
411: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
412: