APPS.IGF_SL_DL_PRINT_MANIFEST dependencies on IGF_AP_FA_BASE_REC

Line 95: cp_person_id igf_ap_fa_base_rec.person_id%TYPE) IS

91:
92: /* get all the records which have the pnote_status set as 'Signed' for the given award year,loan_category etc */
93: CURSOR c_lor_signed(l_cal igf_sl_dl_setup.ci_cal_type%TYPE,
94: l_seq igf_sl_dl_setup.ci_sequence_number%TYPE,
95: cp_person_id igf_ap_fa_base_rec.person_id%TYPE) IS
96: SELECT lor.student_id,
97: lor.p_person_id,
98: lor.loan_id,
99: lor.loan_number,

Line 130: l_person_id igf_ap_fa_base_rec.person_id%TYPE;

126: r_dl_lor_rec c_lor_rec%ROWTYPE;
127:
128: TYPE get_student_ref IS REF CURSOR;
129: get_student_rec get_student_ref;
130: l_person_id igf_ap_fa_base_rec.person_id%TYPE;
131:
132: BEGIN
133:
134: RETCODE := 0;

Line 168: select person_id from igf_ap_fa_base_rec

164:
165: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
166:
167: OPEN get_student_rec FOR
168: select person_id from igf_ap_fa_base_rec
169: where base_id = p_base_id and person_id IS NOT NULL;
170: FETCH get_student_rec INTO l_person_id ;
171: CLOSE get_student_rec;
172: