APPS.IGF_SL_CL_ORIG dependencies on IGS_LOOKUP_VALUES

Line 1440: FROM igs_lookup_values lkup,

1436: -- FA 161 - rajagupt - Bug # 5006583
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