DBA Data[Home] [Help]

APPS.IGF_SL_GEN dependencies on IGS_LOOKUP_VALUES

Line 1056: cp_lookup_type igs_lookup_values.lookup_type%TYPE

1052:
1053:
1054: CURSOR c_get_citzn_status (
1055: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
1056: cp_lookup_type igs_lookup_values.lookup_type%TYPE
1057: )
1058: IS
1059: SELECT lkup.tag,
1060: pct.restatus_code

Line 1061: FROM igs_lookup_values lkup,

1057: )
1058: IS
1059: SELECT lkup.tag,
1060: pct.restatus_code
1061: FROM igs_lookup_values lkup,
1062: igs_pe_eit_restatus_v pct
1063: WHERE lkup.lookup_type = cp_lookup_type
1064: AND lkup.lookup_code = pct.restatus_code
1065: AND pct.person_id = cp_person_id