eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_AW_AWARD_ALL

Line 278: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%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: );
282:

Line 601: CURSOR c_igf_aw_award_v (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

597:
598: rec_c_igf_sl_lor c_igf_sl_lor%ROWTYPE;
599:
600: -- bug# 5045781
601: CURSOR c_igf_aw_award_v (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
602: SELECT fmast.ci_cal_type ci_cal_type,
603: fmast.ci_sequence_number ci_sequence_number,
604: ci.alternate_code ci_alternate_code,
605: ci.start_dt ci_start_dt,

Line 614: FROM igf_aw_award_all awd,

610: pe.party_number person_number,
611: pit.api_person_id ssn,
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,

Line 643: l_n_award_id igf_aw_award_all.award_id%TYPE;

639: l_v_cl_file_type igf_sl_cl_file_type.cl_file_type%TYPE;
640: e_skip EXCEPTION;
641: rec_scr_sl_resp igf_sl_cl_resp_r1_all%ROWTYPE;
642: l_v_rec_type_ind igf_sl_lor_all.rec_type_ind%TYPE;
643: l_n_award_id igf_aw_award_all.award_id%TYPE;
644: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
645: l_n_resp_fls_approved_amt igf_sl_cl_resp_r1_all.fls_approved_amt%TYPE;
646: l_n_resp_flu_approved_amt igf_sl_cl_resp_r1_all.flu_approved_amt%TYPE;
647: l_n_resp_flp_approved_amt igf_sl_cl_resp_r1_all.flp_approved_amt%TYPE;

Line 6372: p_n_award_accept_amt IN igf_aw_award_all.accepted_amt%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
6376: ------------------------------------------------------------------