APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_AW_FUND_CAT_ALL

Line 277: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,

273: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
274: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
275: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
276: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
277: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
278: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,
279: p_n_guarantee_amt IN igf_sl_cl_resp_r1_all.guarantee_amt%TYPE,
280: p_n_approved_amt IN igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE
281: );

Line 616: igf_aw_fund_cat_all fcat,

612: pe.person_last_name || ',' || pe.person_first_name full_name,
613: awd.accepted_amt accepted_amt
614: FROM igf_aw_award_all awd,
615: igf_aw_fund_mast_all fmast,
616: igf_aw_fund_cat_all fcat,
617: igs_ca_inst ci,
618: igf_ap_fa_base_rec facon,
619: (SELECT api_person_id,
620: pe_person_id

Line 6371: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,

6367: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
6368: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
6369: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
6370: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
6371: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
6372: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%TYPE,
6373: p_n_guarantee_amt IN igf_sl_cl_resp_r1_all.guarantee_amt%TYPE,
6374: p_n_approved_amt IN igf_sl_cl_resp_r1_all.alt_approved_amt%TYPE
6375: ) AS