APPS.IGF_SL_CL_ORIG dependencies on IGS_PE_EIT_RESTATUS_V

Line 1441: igs_pe_eit_restatus_v pct

1437: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS
1438: SELECT
1439: pct.restatus_code restatus_code
1440: FROM igs_lookup_values lkup,
1441: igs_pe_eit_restatus_v pct
1442: WHERE lkup.lookup_type = 'PE_CITI_STATUS'
1443: AND trim(lkup.lookup_code) = trim(pct.restatus_code)
1444: AND pct.person_id = cp_person_id
1445: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);