APPS.IGF_SL_DL_RECORD dependencies on IGF_AP_MATCHING_PROCESS_PKG

Line 614: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(student_dtl_rec.p_ssn),9)

610: SELECT l_lor_details.award_id award_id,
611: l_lor_details.loan_id loan_id,
612: l_lor_details.loan_number loan_number,
613: RPAD(l_lor_details.loan_number,21) -- #1
614: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(student_dtl_rec.p_ssn),9)
615: ||RPAD(NVL(UPPER(student_dtl_rec.p_first_name) ,' '),12)
616: ||RPAD(NVL(UPPER(student_dtl_rec.p_last_name) ,' '),16)
617: ||RPAD(NVL(UPPER(student_dtl_rec.p_middle_name) ,' '), 1)
618: ||RPAD(NVL(UPPER(student_dtl_rec.p_permt_addr1)||' '||UPPER(student_dtl_rec.p_permt_addr2),' ') ,35)

Line 676: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(parent_dtl_rec.p_ssn),9)

672: SELECT l_lor_details.award_id award_id,
673: l_lor_details.loan_id loan_id,
674: l_lor_details.loan_number loan_number,
675: RPAD(l_lor_details.loan_number,21) -- #1
676: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(parent_dtl_rec.p_ssn),9)
677: ||RPAD(NVL(UPPER(parent_dtl_rec.p_first_name),' ') ,12)
678: ||RPAD(NVL(UPPER(parent_dtl_rec.p_last_name),' ') ,16)
679: ||RPAD(NVL(UPPER(parent_dtl_rec.p_middle_name) ,' ') ,1)
680: ||RPAD(NVL(UPPER(parent_dtl_rec.p_permt_addr1)||' '||UPPER(parent_dtl_rec.p_permt_addr2),' ') ,35)

Line 699: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(student_dtl_rec.p_ssn), 9)

695: ||RPAD(p_dl_batch_id,23) -- #101
696: ||RPAD(NVL(l_lor_details.pnote_print_ind ,' '), 1)
697: ||RPAD(' ', 1) --unsub_elig_for_depnt is N/A for PLUS
698: ||LPAD(NVL(LTRIM(TO_CHAR(l_lor_details.orig_fee_perct*1000,'00000')),'0'),5) -- Ltrim() done to remove sign char space
699: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(student_dtl_rec.p_ssn), 9)
700: ||RPAD(NVL(UPPER(student_dtl_rec.p_first_name) ,' '),12)
701: ||RPAD(NVL(UPPER(student_dtl_rec.p_last_name) ,' '),16)
702: ||RPAD(NVL(UPPER(student_dtl_rec.p_middle_name) ,' '), 1)
703: ||RPAD(NVL(l_lor_details.citizenship_status ,' '), 1)

Line 737: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(student_dtl_rec.p_ssn),9)

733: SELECT l_lor_details.award_id award_id,
734: l_lor_details.loan_id loan_id,
735: l_lor_details.loan_number loan_number,
736: RPAD(l_lor_details.loan_number,21) -- #1
737: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(student_dtl_rec.p_ssn),9)
738: ||RPAD(NVL(UPPER(student_dtl_rec.p_first_name) ,' '),12)
739: ||RPAD(NVL(UPPER(student_dtl_rec.p_last_name) ,' '),16)
740: ||RPAD(NVL(UPPER(student_dtl_rec.p_middle_name) ,' '), 1)
741: ||RPAD(NVL(UPPER(student_dtl_rec.p_permt_addr1)||' '||UPPER(student_dtl_rec.p_permt_addr2),' ') ,35)

Line 799: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(parent_dtl_rec.p_ssn),9)

795: SELECT l_lor_details.award_id award_id,
796: l_lor_details.loan_id loan_id,
797: l_lor_details.loan_number loan_number,
798: RPAD(l_lor_details.loan_number,21) -- #1
799: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(parent_dtl_rec.p_ssn),9)
800: ||RPAD(NVL(UPPER(parent_dtl_rec.p_first_name),' ') ,12)
801: ||RPAD(NVL(UPPER(parent_dtl_rec.p_last_name),' ') ,16)
802: ||RPAD(NVL(UPPER(parent_dtl_rec.p_middle_name) ,' ') ,1)
803: ||RPAD(NVL(UPPER(parent_dtl_rec.p_permt_addr1)||' '||UPPER(parent_dtl_rec.p_permt_addr2),' ') ,35)

Line 822: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(student_dtl_rec.p_ssn), 9)

818: ||RPAD(p_dl_batch_id,23) -- #101
819: ||RPAD(NVL(l_lor_details.pnote_print_ind ,' '), 1)
820: ||RPAD(' ', 1) --unsub_elig_for_depnt is N/A for PLUS
821: ||LPAD(NVL(LTRIM(TO_CHAR(l_lor_details.orig_fee_perct*1000,'00000')),'0'),5) -- Ltrim() done to remove sign char space
822: ||LPAD(igf_ap_matching_process_pkg.remove_spl_chr(student_dtl_rec.p_ssn), 9)
823: ||RPAD(NVL(UPPER(student_dtl_rec.p_first_name) ,' '),12)
824: ||RPAD(NVL(UPPER(student_dtl_rec.p_last_name) ,' '),16)
825: ||RPAD(NVL(UPPER(student_dtl_rec.p_middle_name) ,' '), 1)
826: ||RPAD(NVL(l_lor_details.citizenship_status ,' '), 1)