APPS.IGF_SL_DL_PRINT_PNOTE dependencies on IGF_AW_AWARD

Line 130: igf_aw_award awd,

126: prsn.surname,
127: prsn.middle_name,
128: prsn.birth_dt
129: FROM igf_sl_loans loans,
130: igf_aw_award awd,
131: igf_ap_fa_base_rec fa,
132: igf_ap_person_v prsn
133: WHERE loans.loan_id = x_loan_id
134: AND loans.award_id = awd.award_id

Line 160: igf_aw_award awd,

156: parent.middle_name p_middle_name,
157: parent.birth_dt p_date_of_birth
158: FROM igf_sl_lor lor,
159: igf_sl_loans loans,
160: igf_aw_award awd,
161: igf_ap_fa_base_rec fa,
162: igf_ap_person_v prsn,
163: igs_pe_person_v parent
164: WHERE lor.loan_id = x_loan_id

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