[Home] [Help]
551: x_batch_seq_num => l_batch_seq_num,
552: x_loan_id => r_dl_orig_rec.loan_id,
553: x_loan_number => r_stafford_det.loan_number,
554: x_person_id => r_stafford_det.student_id,
555: x_s_ssn => SUBSTR(igf_ap_matching_process_pkg.remove_spl_chr(r_stafford_det.s_ssn),1,9),
556: x_s_first_name => r_stafford_det.given_names,
557: x_s_last_name => r_stafford_det.surname,
558: x_s_middle_name => r_stafford_det.middle_name,
559: x_s_date_of_birth => r_stafford_det.birth_dt,
662: x_loan_amt_accepted => r_plus_det.loan_amt_accepted,
663: x_loan_per_begin_date => r_plus_det.loan_per_begin_date,
664: x_loan_per_end_date => r_plus_det.loan_per_end_date,
665: x_person_id => r_plus_det.student_id,
666: x_s_ssn => SUBSTR(igf_ap_matching_process_pkg.remove_spl_chr(r_plus_det.s_ssn),1,9),
667: x_s_first_name => r_plus_det.given_names,
668: x_s_last_name => r_plus_det.surname,
669: x_s_middle_name => r_plus_det.middle_name,
670: x_s_date_of_birth => r_plus_det.birth_dt,
682: x_s_permt_zip => student_dtl_rec.p_permt_zip,
683: x_s_email_addr => student_dtl_rec.p_email_addr,
684: x_s_phone => l_person_phone,
685: x_p_person_id => r_plus_det.p_person_id,
686: x_p_ssn => SUBSTR(igf_ap_matching_process_pkg.remove_spl_chr(r_plus_det.api_person_id),1,9),
687: x_p_last_name => parent_dtl_rec.p_last_name,
688: x_p_first_name => parent_dtl_rec.p_first_name,
689: x_p_middle_name => parent_dtl_rec.p_middle_name,
690: x_p_date_of_birth => parent_dtl_rec.p_date_of_birth,