APPS.IGF_SL_CL_CHG_PRC dependencies on IGS_PE_ALT_PERS_ID

Line 101: l_v_school_id igs_pe_alt_pers_id.person_id_type%TYPE;

97: l_n_award_id igf_aw_award_all.award_id%TYPE;
98: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
99: l_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
100: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;
101: l_v_school_id igs_pe_alt_pers_id.person_id_type%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;

Line 399: l_person_ssn igs_pe_alt_pers_id.person_id_type%TYPE;

395: --Who When What
396: ------------------------------------------------------------------
397: c_person_dtl_cur igf_sl_gen.person_dtl_cur;
398: rec_c_person_dtl_cur igf_sl_gen.person_dtl_rec;
399: l_person_ssn igs_pe_alt_pers_id.person_id_type%TYPE;
400: BEGIN
401:
402: log_to_fnd(p_v_module => 'validate_ssn ',
403: p_v_string => 'Private function validate_ssn input parameter p_n_person_id = '||p_n_person_id