APPS.IGF_SL_REJ_WF dependencies on IGF_SL_LOANS

Line 51: l_loanid igf_sl_loans_v.loan_id%TYPE;

47: smvk 21-Feb-2003 Bug # 2758823. Work flow event is triggered with proper lookupcode / meaning
48: (reverse chronological order - newest change first)
49: ***************************************************************/
50: l_batchid igf_sl_dl_batch.dbth_id%TYPE;
51: l_loanid igf_sl_loans_v.loan_id%TYPE;
52: l_loannum igf_sl_loans_v.loan_number%TYPE;
53: l_name igf_sl_loans_v.full_name%TYPE;
54: l_ssn igf_sl_loans_v.s_ssn%TYPE;
55: l_pernum igf_sl_loans_v.person_number%TYPE;

Line 52: l_loannum igf_sl_loans_v.loan_number%TYPE;

48: (reverse chronological order - newest change first)
49: ***************************************************************/
50: l_batchid igf_sl_dl_batch.dbth_id%TYPE;
51: l_loanid igf_sl_loans_v.loan_id%TYPE;
52: l_loannum igf_sl_loans_v.loan_number%TYPE;
53: l_name igf_sl_loans_v.full_name%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;

Line 53: l_name igf_sl_loans_v.full_name%TYPE;

49: ***************************************************************/
50: l_batchid igf_sl_dl_batch.dbth_id%TYPE;
51: l_loanid igf_sl_loans_v.loan_id%TYPE;
52: l_loannum igf_sl_loans_v.loan_number%TYPE;
53: l_name igf_sl_loans_v.full_name%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);

Line 54: l_ssn igf_sl_loans_v.s_ssn%TYPE;

50: l_batchid igf_sl_dl_batch.dbth_id%TYPE;
51: l_loanid igf_sl_loans_v.loan_id%TYPE;
52: l_loannum igf_sl_loans_v.loan_number%TYPE;
53: l_name igf_sl_loans_v.full_name%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;

Line 55: l_pernum igf_sl_loans_v.person_number%TYPE;

51: l_loanid igf_sl_loans_v.loan_id%TYPE;
52: l_loannum igf_sl_loans_v.loan_number%TYPE;
53: l_name igf_sl_loans_v.full_name%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);

Line 70: FROM igf_sl_loans_v

66: SELECT loan_number,
67: full_name,
68: s_ssn,
69: person_number
70: FROM igf_sl_loans_v
71: WHERE loan_id = l_loanid ;
72:
73: CURSOR c_pnote_resp IS
74: SELECT igf_sl_dl_pnote_resp.pnote_rej_codes

Line 78: FROM igf_sl_loans

74: SELECT igf_sl_dl_pnote_resp.pnote_rej_codes
75: FROM igf_sl_dl_pnote_resp
76: WHERE dbth_id = l_batchid
77: AND loan_number = (SELECT loan_number
78: FROM igf_sl_loans
79: WHERE loan_id = l_loanid);
80:
81:
82: CURSOR c_rej IS

Line 273: l_loanid igf_sl_loans_v.loan_id%TYPE;

269: chg_batch_id,appl_send_error_codes from igf_sl_lor
270: (reverse chronological order - newest change first)
271: ***************************************************************/
272:
273: l_loanid igf_sl_loans_v.loan_id%TYPE;
274: l_tbh_rec igf_sl_lor%ROWTYPE;
275:
276: CURSOR c_tbh_cur IS
277: SELECT * FROM igf_sl_lor

Line 474: l_loanid igf_sl_loans_v.loan_id%TYPE;

470: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
471: chg_batch_id,appl_send_error_codes from igf_sl_lor
472: (reverse chronological order - newest change first)
473: ***************************************************************/
474: l_loanid igf_sl_loans_v.loan_id%TYPE;
475: l_tbh_rec igf_sl_lor%ROWTYPE;
476:
477: CURSOR c_tbh_cur IS
478: SELECT * FROM igf_sl_lor