APPS.IGF_SL_CL_CHG_PRC dependencies on IGF_AW_AWARD_ALL

Line 80: CURSOR c_igf_aw_award (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

76: ,lor.cl_seq_number cl_seq_number
77: FROM igf_sl_lor_all lor
78: WHERE lor.loan_id = cp_n_loan_id;
79:
80: CURSOR c_igf_aw_award (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
81: SELECT awd.base_id
82: FROM igf_aw_award_all awd
83: WHERE awd.award_id = cp_n_award_id;
84:

Line 82: FROM igf_aw_award_all awd

78: WHERE lor.loan_id = cp_n_loan_id;
79:
80: CURSOR c_igf_aw_award (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
81: SELECT awd.base_id
82: FROM igf_aw_award_all awd
83: WHERE awd.award_id = cp_n_award_id;
84:
85: CURSOR c_igf_ap_fa_base_rec (cp_n_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
86: SELECT fabase.person_id

Line 97: l_n_award_id igf_aw_award_all.award_id%TYPE;

93: FROM igf_sl_cl_recipient rcpt
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;