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.

[Home] [Help]

APPS.IGF_SL_DL_VALIDATION dependencies on IGF_SL_LOANS_ALL

Line 23: g_loan_id igf_sl_Loans_all.loan_id%TYPE;

19: --
20: -------------------------------------------------------------------------
21:
22: p_dl_version igf_lookups_view.lookup_code%TYPE;
23: g_loan_id igf_sl_Loans_all.loan_id%TYPE;
24: student_dtl_rec igf_sl_gen.person_dtl_rec;
25: parent_dtl_rec igf_sl_gen.person_dtl_rec;
26:
27: CURSOR cur_disb(c_award_id igf_aw_awd_disb.award_id%TYPE) IS

Line 62: CURSOR cur_loan_at_cod ( cp_loan_number igf_sl_loans_all.loan_number%TYPE) IS

58: WHERE base_id = p_base_id
59: AND payment_isir = 'Y'
60: AND system_record_type = 'ORIGINAL';
61:
62: CURSOR cur_loan_at_cod ( cp_loan_number igf_sl_loans_all.loan_number%TYPE) IS
63: SELECT 'x'
64: FROM igf_sl_lor_loc_history
65: WHERE loan_number = cp_loan_number;
66:

Line 301: p_loan_number igf_sl_loans_all.loan_number%TYPE,

297: /* MAIN PROCEDURE */
298: FUNCTION dl_lar_validate(p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
299: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
300: p_loan_catg fnd_lookups.lookup_code%TYPE,
301: p_loan_number igf_sl_loans_all.loan_number%TYPE,
302: p_call_mode VARCHAR2,
303: p_school_code VARCHAR2 )
304: RETURN BOOLEAN
305: AS

Line 338: lv_loan_status igf_sl_loans_all.loan_status%TYPE;

334: (reverse chronological order - newest change first)
335: ***************************************************************/
336:
337: lv_loan_catg igf_sl_reqd_fields.loan_type%TYPE;
338: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
339: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
340: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;

Line 345: l_status_1 igf_sl_loans_all.loan_status%TYPE;

341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;
343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
345: l_status_1 igf_sl_loans_all.loan_status%TYPE;
346: l_status_2 igf_sl_loans_all.loan_status%TYPE;
347: l_status_3 igf_sl_loans_all.loan_status%TYPE;
348: l_fed_fund_1 igf_aw_fund_cat_all.fed_fund_code%TYPE;
349: l_fed_fund_2 igf_aw_fund_cat_all.fed_fund_code%TYPE;

Line 346: l_status_2 igf_sl_loans_all.loan_status%TYPE;

342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;
343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
345: l_status_1 igf_sl_loans_all.loan_status%TYPE;
346: l_status_2 igf_sl_loans_all.loan_status%TYPE;
347: l_status_3 igf_sl_loans_all.loan_status%TYPE;
348: l_fed_fund_1 igf_aw_fund_cat_all.fed_fund_code%TYPE;
349: l_fed_fund_2 igf_aw_fund_cat_all.fed_fund_code%TYPE;
350: student_dtl_cur igf_sl_gen.person_dtl_cur;

Line 347: l_status_3 igf_sl_loans_all.loan_status%TYPE;

343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
345: l_status_1 igf_sl_loans_all.loan_status%TYPE;
346: l_status_2 igf_sl_loans_all.loan_status%TYPE;
347: l_status_3 igf_sl_loans_all.loan_status%TYPE;
348: l_fed_fund_1 igf_aw_fund_cat_all.fed_fund_code%TYPE;
349: l_fed_fund_2 igf_aw_fund_cat_all.fed_fund_code%TYPE;
350: student_dtl_cur igf_sl_gen.person_dtl_cur;
351: parent_dtl_cur igf_sl_gen.person_dtl_cur;

Line 410: igf_sl_loans_all loans,

406: awd.accepted_amt,
407: lor.grade_level_code,
408: lor.override_grade_level_code
409: FROM
410: igf_sl_loans_all loans,
411: igf_sl_lor_all lor,
412: igf_aw_award_all awd,
413: igf_aw_fund_mast_all fmast,
414: igf_aw_fund_cat_all fcat,

Line 435: FROM igf_sl_loans_all loans,

431: -- museshad (Bug 4116399)
432: CURSOR cur_get_fed_fund_code(cp_loan_number igf_sl_loans.loan_number%TYPE)
433: IS
434: SELECT fcat.fed_fund_code
435: FROM igf_sl_loans_all loans,
436: igf_aw_award_all awd,
437: igf_aw_fund_mast_all fmast,
438: igf_aw_fund_cat_all fcat
439: WHERE