[Home] [Help]
776: l_ssn igf_ap_isir_matched_all.current_ssn%TYPE;
777:
778: x_return_status VARCHAR2(1);
779: x_msg_data VARCHAR2(30);
780: x_dlsch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
781: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
782: x_sch_non_ed_brc_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
783:
784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
777:
778: x_return_status VARCHAR2(1);
779: x_msg_data VARCHAR2(30);
780: x_dlsch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
781: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
782: x_sch_non_ed_brc_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
783:
784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
785: SELECT rowid
778: x_return_status VARCHAR2(1);
779: x_msg_data VARCHAR2(30);
780: x_dlsch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
781: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
782: x_sch_non_ed_brc_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
783:
784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
785: SELECT rowid
786: FROM igf_sl_loans_all