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 dependencies on IGF_AP_FA_BASE_REC

Line 204: CURSOR cur_loan_dtls(p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,

200:
201: recip_desc_rec cur_recip_desc%ROWTYPE;
202:
203: -- To fetch the Loan Records based on the Recepient Information
204: CURSOR cur_loan_dtls(p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
205: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
206: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
207: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
208: p_loan_number igf_sl_loans.loan_number%TYPE,

Line 205: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,

201: recip_desc_rec cur_recip_desc%ROWTYPE;
202:
203: -- To fetch the Loan Records based on the Recepient Information
204: CURSOR cur_loan_dtls(p_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
205: p_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
206: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
207: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
208: p_loan_number igf_sl_loans.loan_number%TYPE,
209: p_loan_status igf_sl_loans.loan_status%TYPE,

Line 343: igf_ap_fa_base_rec_all fabase,

339: igf_sl_lor_all lor,
340: igf_aw_award_all awd,
341: igf_aw_fund_mast_all fmast,
342: igf_aw_fund_cat_all fcat,
343: igf_ap_fa_base_rec_all fabase,
344: igf_sl_cl_recipient recip
345: WHERE fabase.ci_cal_type = p_cal_type
346: AND fabase.ci_sequence_number = p_seq_number
347: AND fabase.base_id = awd.base_id

Line 424: FROM igf_ap_fa_base_rec fabase,

420: p_enabled_flag igf_lookups_view.enabled_flag%TYPE,
421: p_recipient_id VARCHAR2
422: ) IS
423: SELECT DISTINCT lor.relationship_cd
424: FROM igf_ap_fa_base_rec fabase,
425: igf_sl_loans lar,
426: igf_sl_lor lor,
427: igf_aw_award awd,
428: igf_aw_fund_mast fund,

Line 692: p_n_coa IN igf_ap_fa_base_rec_all.coa_f%TYPE,

688:
689:
690: PROCEDURE insert_lor_loc_rec (
691: p_v_school_id IN VARCHAR2,
692: p_n_coa IN igf_ap_fa_base_rec_all.coa_f%TYPE,
693: p_n_efc IN igf_ap_fa_base_rec_all.efc_f%TYPE,
694: p_n_est_fin IN igf_aw_award_all.accepted_amt%TYPE,
695: p_c_alt_borr_ind_flag IN VARCHAR2
696: ) AS

Line 693: p_n_efc IN igf_ap_fa_base_rec_all.efc_f%TYPE,

689:
690: PROCEDURE insert_lor_loc_rec (
691: p_v_school_id IN VARCHAR2,
692: p_n_coa IN igf_ap_fa_base_rec_all.coa_f%TYPE,
693: p_n_efc IN igf_ap_fa_base_rec_all.efc_f%TYPE,
694: p_n_est_fin IN igf_aw_award_all.accepted_amt%TYPE,
695: p_c_alt_borr_ind_flag IN VARCHAR2
696: ) AS
697:

Line 1259: l_coa igf_ap_fa_base_rec_all.coa_f%TYPE;

1255: lv_file_ident_name igf_sl_cl_file_type.file_ident_name%TYPE;
1256: lv_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;
1257: lv_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1258: lv_recip_non_ed_brc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;
1259: l_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
1260: l_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
1261: lv_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
1262: lv_eft_authorization igf_sl_cl_setup.eft_authorization%TYPE;
1263: l_dummy_pell_efc NUMBER;

Line 1260: l_efc igf_ap_fa_base_rec_all.efc_f%TYPE;

1256: lv_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;
1257: lv_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1258: lv_recip_non_ed_brc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;
1259: l_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
1260: l_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
1261: lv_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
1262: lv_eft_authorization igf_sl_cl_setup.eft_authorization%TYPE;
1263: l_dummy_pell_efc NUMBER;
1264:

Line 1350: FROM igf_ap_fa_base_rec fabase, igf_ap_isir_matched isir

1346:
1347: CURSOR cur_isir_depend_status
1348: IS
1349: SELECT isir.dependency_status
1350: FROM igf_ap_fa_base_rec fabase, igf_ap_isir_matched isir
1351: WHERE isir.base_id = fabase.base_id
1352: AND fabase.person_id = loan_rec.student_id
1353: AND isir.payment_isir = 'Y'
1354: AND isir.system_record_type = 'ORIGINAL';

Line 1382: FROM igf_ap_fa_base_rec

1378: --Cursor to fetch the data from the FA Base Record for the student baseid
1379: CURSOR cur_get_fabase
1380: IS
1381: SELECT TRUNC(coa_f)
1382: FROM igf_ap_fa_base_rec
1383: WHERE base_id = loan_rec.base_id;
1384:
1385: --Fetch the Estimated Financial Aid
1386: CURSOR cur_get_fin_aid(

Line 1792: fnd_message.set_token('P_RECORD','igf_ap_fa_base_rec');

1788: FETCH cur_isir_depend_status INTO lv_dependency_status;
1789: IF cur_isir_depend_status%NOTFOUND THEN
1790: CLOSE cur_isir_depend_status;
1791: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
1792: fnd_message.set_token('P_RECORD','igf_ap_fa_base_rec');
1793: fnd_file.put_line(fnd_file.log,fnd_message.get);
1794: IF(fnd_log.level_statement >= g_debug_runtime_level)THEN
1795: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug','Record Data not found');
1796: END IF;