APPS.IGF_SL_DL_PRINT_MANIFEST dependencies on IGF_LOOKUPS_VIEW

Line 47: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,

43: PROCEDURE process_manifest(
44: ERRBUF OUT NOCOPY VARCHAR2,
45: RETCODE OUT NOCOPY NUMBER,
46: p_award_year IN VARCHAR2,
47: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
48: p_base_id IN igf_aw_award.base_id%TYPE, -- modified to receive base_id instead of student id
49: p_loan_number IN igf_sl_loans_v.loan_number%TYPE,
50: p_org_id IN NUMBER
51: )

Line 108: FROM igf_lookups_view

104: FROM igf_sl_lor_v lor,
105: igf_ap_person_v per
106: WHERE lor.pnote_status = 'S' /* Check for pnote_status 'Signed' */
107: AND lor.fed_fund_code IN (SELECT DISTINCT lookup_code
108: FROM igf_lookups_view
109: WHERE lookup_type = DECODE(p_loan_catg,'DL_STAFFORD','IGF_SL_DL_STAFFORD','DL_PLUS','IGF_SL_DL_PLUS')
110: )
111: AND lor.ci_cal_type = l_cal /* Check for given Award Year */
112: AND lor.ci_sequence_number = l_seq