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_CHG_FILE dependencies on IGF_SL_LOR_ALL

Line 42: anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE,

38: loan_number igf_sl_loans_all.loan_number%TYPE,
39: loan_status igf_sl_loans_all.loan_status%TYPE,
40: loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE,
41: loan_active igf_sl_loans_all.active%TYPE,
42: anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE,
43: sch_cert_date igf_sl_lor_all.sch_cert_date%TYPE,
44: loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
45: loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE,
46: cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE,

Line 43: sch_cert_date igf_sl_lor_all.sch_cert_date%TYPE,

39: loan_status igf_sl_loans_all.loan_status%TYPE,
40: loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE,
41: loan_active igf_sl_loans_all.active%TYPE,
42: anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE,
43: sch_cert_date igf_sl_lor_all.sch_cert_date%TYPE,
44: loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
45: loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE,
46: cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE,
47: prc_type_code igf_sl_lor_all.prc_type_code%TYPE,

Line 46: cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE,

42: anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE,
43: sch_cert_date igf_sl_lor_all.sch_cert_date%TYPE,
44: loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
45: loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE,
46: cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE,
47: prc_type_code igf_sl_lor_all.prc_type_code%TYPE,
48: cl_version igf_sl_cl_setup_all.cl_version%TYPE
49: );
50:

Line 47: prc_type_code igf_sl_lor_all.prc_type_code%TYPE,

43: sch_cert_date igf_sl_lor_all.sch_cert_date%TYPE,
44: loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
45: loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE,
46: cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE,
47: prc_type_code igf_sl_lor_all.prc_type_code%TYPE,
48: cl_version igf_sl_cl_setup_all.cl_version%TYPE
49: );
50:
51: -- procedure for enabling statement level logging

Line 198: FROM igf_sl_lor_all lor

194: cp_c_loan_chg_status IN igf_sl_loans_all.loan_chg_status%TYPE,
195: cp_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE
196: ) IS
197: SELECT DISTINCT lor.relationship_cd
198: FROM igf_sl_lor_all lor
199: ,igf_sl_loans_all loans
200: ,igf_aw_award_all awd
201: ,igf_aw_fund_mast_all fmast
202: ,igf_sl_cl_recipient recip

Line 1038: FROM igf_sl_lor_all lor

1034: ,fmast.fund_code
1035: ,fmast.discontinue_fund
1036: ,fcat.fed_fund_code
1037: ,clset.cl_version
1038: FROM igf_sl_lor_all lor
1039: ,igf_sl_loans loans
1040: ,igf_aw_award_all awd
1041: ,igf_aw_fund_mast_all fmast
1042: ,igf_aw_fund_cat_all fcat

Line 1528: FROM igf_sl_lor_all lor

1524: ,fmast.fund_code
1525: ,fcat.fed_fund_code
1526: ,fabase.person_id student_id
1527: ,TRUNC(fabase.coa_f) coa_f
1528: FROM igf_sl_lor_all lor
1529: ,igf_sl_loans_all loans
1530: ,igf_aw_award_all awd
1531: ,igf_aw_fund_mast_all fmast
1532: ,igf_aw_fund_cat_all fcat

Line 1636: cp_n_origination_id igf_sl_lor_all.origination_id%TYPE

1632: AND awd.award_id <> cp_n_award_id
1633: AND (awd.award_status IN (cp_awd_status_1,cp_awd_status_2));
1634:
1635: CURSOR c_sl_lor_loc (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE ,
1636: cp_n_origination_id igf_sl_lor_all.origination_id%TYPE
1637: ) IS
1638: SELECT lorloc.*, lorloc.ROWID row_id
1639: FROM igf_sl_lor_loc_all lorloc
1640: WHERE loan_id = cp_n_loan_id

Line 1694: l_v_alt_prog_type_code igf_sl_lor_all.alt_prog_type_code%TYPE;

1690: -- variables for (@1-07)
1691: l_v_chg_01_7_rec VARCHAR2(4000);
1692: l_c_01_07_flg VARCHAR2(1);
1693: l_v_loan_type igf_aw_fund_cat_all.fed_fund_code%TYPE;
1694: l_v_alt_prog_type_code igf_sl_lor_all.alt_prog_type_code%TYPE;
1695: c_student_dtls igf_sl_gen.person_dtl_cur;
1696: rec_student_dtls igf_sl_gen.person_dtl_rec;
1697: l_d_revised_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1698: l_d_revised_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;