APPS.IGF_SL_CL_CHG_PRC dependencies on IGF_SL_LOR_ALL

Line 77: FROM igf_sl_lor_all lor

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
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

Line 106: l_n_cl_seq_number igf_sl_lor_all.cl_seq_number%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;
105: l_v_lender_id igf_sl_lender.lender_id%TYPE;
106: l_n_cl_seq_number igf_sl_lor_all.cl_seq_number%TYPE;
107: l_v_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
108: l_v_message_name fnd_new_messages.message_name%TYPE;
109: l_b_return_status BOOLEAN;
110: l_loan_tab igf_aw_packng_subfns.std_loan_tab ;