APPS.IGF_SL_CL_CHG_PRC dependencies on IGF_SL_LOANS_ALL

Line 54: CURSOR c_igf_sl_lor_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS

50: --
51: --Change History:
52: --Who When What
53: ------------------------------------------------------------------
54: CURSOR c_igf_sl_lor_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
55: SELECT isl.anticip_compl_date anticipated_completion_date
56: ,islv.loan_per_end_date loan_end_date
57: FROM igf_sl_lor_v isl,
58: igf_sl_loans_v islv

Line 68: CURSOR c_igf_sl_loans (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS

64: ,clchgsnd.loan_number_txt
65: FROM igf_sl_clchsn_dtls clchgsnd
66: WHERE clchgsnd.clchgsnd_id = cp_n_clchgsnd_id;
67:
68: CURSOR c_igf_sl_loans (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
69: SELECT lar.loan_id
70: FROM igf_sl_loans_all lar
71: WHERE lar.loan_number = cp_v_loan_number;
72:

Line 70: FROM igf_sl_loans_all lar

66: WHERE clchgsnd.clchgsnd_id = cp_n_clchgsnd_id;
67:
68: CURSOR c_igf_sl_loans (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
69: SELECT lar.loan_id
70: FROM igf_sl_loans_all lar
71: WHERE lar.loan_number = cp_v_loan_number;
72:
73: CURSOR c_igf_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
74: SELECT lor.p_person_id borrower_id

Line 73: CURSOR c_igf_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS

69: SELECT lar.loan_id
70: FROM igf_sl_loans_all lar
71: WHERE lar.loan_number = cp_v_loan_number;
72:
73: CURSOR c_igf_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
74: SELECT lor.p_person_id borrower_id
75: ,lor.relationship_cd relationship_cd
76: ,lor.cl_seq_number cl_seq_number
77: FROM igf_sl_lor_all lor

Line 98: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

94: WHERE relationship_cd = cp_v_relationship_cd;
95:
96: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
97: l_n_award_id igf_aw_award_all.award_id%TYPE;
98: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
99: l_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
100: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;
101: l_v_school_id igs_pe_alt_pers_id.person_id_type%TYPE;
102: l_n_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

Line 100: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;

96: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
97: l_n_award_id igf_aw_award_all.award_id%TYPE;
98: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
99: l_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
100: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;
101: l_v_school_id igs_pe_alt_pers_id.person_id_type%TYPE;
102: l_n_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
103: l_v_relationship_cd igf_sl_cl_recipient.relationship_cd%TYPE;
104: l_v_guarantor_id igf_sl_guarantor.guarantor_id%TYPE;