APPS.IGF_SL_REJ_WF dependencies on IGF_LOOKUPS_VIEW

Line 58: l_label igf_lookups_view.meaning%TYPE;

54: l_ssn igf_sl_loans_v.s_ssn%TYPE;
55: l_pernum igf_sl_loans_v.person_number%TYPE;
56: l_reject_code igf_sl_dl_lor_resp.orig_reject_reasons%TYPE;
57: l_reject_text VARCHAR2(2000);
58: l_label igf_lookups_view.meaning%TYPE;
59: l_heading VARCHAR2(500);
60: l_role VARCHAR2(30);
61: l_n_incr NUMBER;
62: l_c_reject_code igf_sl_dl_lor_resp.orig_reject_reasons%TYPE;

Line 84: FROM igf_lookups_view

80:
81:
82: CURSOR c_rej IS
83: SELECT lookup_code, meaning
84: FROM igf_lookups_view
85: WHERE lookup_type = 'IGF_SL_PNOTE_REJ_CODES'
86: AND lookup_code IN (LTRIM(RTRIM(SUBSTR(l_reject_code, 1,2))),
87: LTRIM(RTRIM(SUBSTR(l_reject_code, 3,2))),
88: LTRIM(RTRIM(SUBSTR(l_reject_code, 5,2))),