APPS.IGF_SL_DL_PRINT_PNOTE dependencies on IGF_LOOKUPS_VIEW

Line 57: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,

53: PROCEDURE process_pnote(
54: ERRBUF OUT NOCOPY VARCHAR2,
55: RETCODE OUT NOCOPY NUMBER,
56: p_award_year IN VARCHAR2,
57: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
58: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
59: p_loan_number IN igf_sl_loans_v.loan_number%TYPE,
60: p_org_id IN NUMBER
61: )AS

Line 103: x_lookup_type igf_lookups_view.lookup_type%TYPE

99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,
100: x_loan_number igf_sl_lor_v.loan_number%TYPE,
101: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,
103: x_lookup_type igf_lookups_view.lookup_type%TYPE
104: ) IS
105: SELECT lor.loan_id
106: FROM igf_sl_lor_v lor, igf_ap_fa_base_rec fa
107: WHERE lor.pnote_status = x_pnote_status AND

Line 111: FROM igf_lookups_view

107: WHERE lor.pnote_status = x_pnote_status AND
108: lor.student_id = fa.person_id AND
109: fa.base_id = NVL(x_base_id,fa.base_id) AND
110: lor.fed_fund_code IN ( SELECT DISTINCT lookup_code
111: FROM igf_lookups_view
112: WHERE lookup_type = x_lookup_type ) AND
113: lor.ci_cal_type = x_ci_cal_type AND
114: lor.ci_sequence_number = x_ci_sequence_number AND
115: lor.loan_number = NVL(x_loan_number, lor.loan_number) AND

Line 205: l_lookup_type igf_lookups_view.lookup_type%TYPE;

201: r_dl_lor_rec c_lor_rec%ROWTYPE;
202: r_stafford_det c_stafford_det%ROWTYPE;
203: r_plus_det c_plus_det%ROWTYPE;
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: