APPS.IGF_SL_DL_PRINT_PNOTE dependencies on IGF_AW_AWARD_V

Line 192: l_person_num igf_aw_award_v.person_number%TYPE;

188: l_rowid VARCHAR2(30);
189: l_log_mesg VARCHAR2(2000);
190: l_pnsp_id igf_sl_dl_pnote_s_p.pnsp_id%TYPE;
191: l_pnpp_id igf_sl_dl_pnote_p_p.pnpp_id%TYPE;
192: l_person_num igf_aw_award_v.person_number%TYPE;
193: l_heading VARCHAR2(100);
194: l_stud_number igf_aw_award_v.person_number%TYPE;
195: l_parent_number igf_aw_award_v.person_number%TYPE;
196: l_ret BOOLEAN DEFAULT FALSE;

Line 194: l_stud_number igf_aw_award_v.person_number%TYPE;

190: l_pnsp_id igf_sl_dl_pnote_s_p.pnsp_id%TYPE;
191: l_pnpp_id igf_sl_dl_pnote_p_p.pnpp_id%TYPE;
192: l_person_num igf_aw_award_v.person_number%TYPE;
193: l_heading VARCHAR2(100);
194: l_stud_number igf_aw_award_v.person_number%TYPE;
195: l_parent_number igf_aw_award_v.person_number%TYPE;
196: l_ret BOOLEAN DEFAULT FALSE;
197: l_prnt_ln igf_sl_loans_all.loan_number%TYPE;
198:

Line 195: l_parent_number igf_aw_award_v.person_number%TYPE;

191: l_pnpp_id igf_sl_dl_pnote_p_p.pnpp_id%TYPE;
192: l_person_num igf_aw_award_v.person_number%TYPE;
193: l_heading VARCHAR2(100);
194: l_stud_number igf_aw_award_v.person_number%TYPE;
195: l_parent_number igf_aw_award_v.person_number%TYPE;
196: l_ret BOOLEAN DEFAULT FALSE;
197: l_prnt_ln igf_sl_loans_all.loan_number%TYPE;
198:
199: r_pnote c_pnote_check%ROWTYPE;

Line 208: l_current_per_num igf_aw_award_v.person_number%TYPE;

204:
205: l_lookup_type igf_lookups_view.lookup_type%TYPE;
206: l_pnote_status igf_sl_lor_v.pnote_status%TYPE;
207:
208: l_current_per_num igf_aw_award_v.person_number%TYPE;
209:
210: SKIP_LOAN_RECORD EXCEPTION;
211:
212: --Internal Procedure to display LOG Message