[Home] [Help]
262:
263: cal_type_rec cal_type_cur%ROWTYPE;
264:
265: --Bug# 5006583 - bvisvana
266: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS
267: SELECT
268: pct.restatus_code
269: FROM igs_pe_eit_restatus_v pct
270: WHERE pct.person_id = cp_person_id
1542:
1543: ln_cur_loan_id igf_sl_loans.loan_id%TYPE;
1544: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
1545: l_party_id igf_sl_cl_setup.party_id%TYPE;
1546: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
1547: l_loan_status VARCHAR2(30);
1548:
1549:
1550: -- cursor to get the base id from the loan id
1609: SELECT p_person_id FROM igf_sl_lor_all
1610: WHERE loan_id = cp_loanid;
1611:
1612: --Bug# 5006583
1613: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS
1614: SELECT
1615: pct.restatus_code
1616: FROM igs_pe_eit_restatus_v pct
1617: WHERE pct.person_id = cp_person_id
2046: SELECT p_person_id FROM igf_sl_lor_all
2047: WHERE loan_id = cp_loanid;
2048:
2049: --Bug# 5006583
2050: CURSOR citizenship_dtl_cur (cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE) IS
2051: SELECT
2052: pct.restatus_code
2053: FROM igs_pe_eit_restatus_v pct
2054: WHERE pct.person_id = cp_person_id
2058: l_cur_fa_rec cur_fa_mapping%ROWTYPE;
2059: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
2060: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
2061: l_party_id igf_sl_cl_setup.party_id%TYPE;
2062: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
2063: alien_dtl_cur igf_sl_gen.person_dtl_cur;
2064: alien_dtl_rec igf_sl_gen.person_dtl_rec;
2065:
2066: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;