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_LAR_CREATION dependencies on IGF_SL_LOANS_ALL

Line 185: CURSOR parent_id_cur (cp_loan_id igf_sl_loans_all.loan_id%TYPE) IS

181: bvisvana 25-Aug-2005 Bug 4127532 - Placed p_student_person_id assignment after the IF condition
182: since we need the student id for ALT loans (student = borrower) irrespective of single parent or not
183: For FLP and DLP only parent is needed and hence if only one parent, that parent_id is returned, else NULL
184: ***************************************************************/
185: CURSOR parent_id_cur (cp_loan_id igf_sl_loans_all.loan_id%TYPE) IS
186: SELECT
187: COUNT(v.row_id) parent_count,
188: MIN(v.object_ID) student_id,
189: MIN(v.SUBJECT_ID) parent_id

Line 193: igf_sl_loans_all loans,

189: MIN(v.SUBJECT_ID) parent_id
190: FROM
191: igs_pe_relationships_v v,
192: igf_aw_award_all awd,
193: igf_sl_loans_all loans,
194: igf_ap_fa_base_rec base
195: WHERE
196: base.person_id = v.object_id
197: AND base.base_id = awd.base_id

Line 236: PROCEDURE populate_cosigner_data (p_loan_id igf_sl_loans_all.loan_id%TYPE,

232: app_exception.raise_exception;
233: END get_borrower_parent_id;
234:
235:
236: PROCEDURE populate_cosigner_data (p_loan_id igf_sl_loans_all.loan_id%TYPE,
237: p_person_id NUMBER) IS
238: /*
239: Change History
240: Who When What

Line 773: lv_loan_number igf_sl_loans_all.loan_number%TYPE;

769: ***************************************************************/
770:
771: lv_loan_type VARCHAR2(100);
772: lv_loan_yr VARCHAR2(2);
773: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
774: lv_incr_seq NUMBER;
775: lv_incr_seq_char VARCHAR2(100);
776: l_ssn igf_ap_isir_matched_all.current_ssn%TYPE;
777:

Line 784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS

780: x_dlsch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
781: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
782: x_sch_non_ed_brc_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
783:
784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
785: SELECT rowid
786: FROM igf_sl_loans_all
787: WHERE loan_number = p_loan_number;
788:

Line 786: FROM igf_sl_loans_all

782: x_sch_non_ed_brc_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
783:
784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
785: SELECT rowid
786: FROM igf_sl_loans_all
787: WHERE loan_number = p_loan_number;
788:
789: loan_num_rec cur_loan_num%ROWTYPE;
790:

Line 1265: FROM IGF_SL_LOANS_ALL lar

1261: pnote_status
1262: ***************************************************************/
1263: CURSOR getloannumber (cp_loan_id NUMBER) is
1264: SELECT LOAN_NUMBER
1265: FROM IGF_SL_LOANS_ALL lar
1266: WHERE lar.LOAN_ID = cp_loan_id;
1267:
1268: lv_row_id ROWID;
1269: ln_origination_id igf_sl_lor_all.origination_id%TYPE;

Line 1555: FROM igf_sl_loans_all loans,

1551: CURSOR c_get_base_id (
1552: cp_loan_id igf_sl_loans.loan_id%TYPE
1553: ) IS
1554: SELECT awd.base_id, awd.award_id
1555: FROM igf_sl_loans_all loans,
1556: igf_aw_award_all awd
1557: WHERE loans.loan_id = cp_loan_id
1558: AND loans.award_id = awd.award_id;
1559:

Line 2000: FROM igf_sl_loans_all loan,

1996: awd.award_status,
1997: awd.accepted_amt,
1998: fmast.ci_cal_type,
1999: fmast.ci_sequence_number
2000: FROM igf_sl_loans_all loan,
2001: igf_aw_award_all awd,
2002: igf_aw_fund_mast_all fmast,
2003: igf_aw_fund_cat_all fcat,
2004: igf_ap_fa_base_rec_all fa

Line 2078: igf_sl_loans_all loans,

2074: 'X'
2075: FROM
2076: igs_pe_relationships_v v,
2077: igf_aw_award_all awd,
2078: igf_sl_loans_all loans,
2079: igf_ap_fa_base_rec base
2080: WHERE
2081: base.person_id = v.object_ID
2082: AND base.base_id = awd.base_id

Line 2624: FROM igf_sl_loans_all loans )

2620: AND awdv.base_id = NVL(p_base_id, awdv.base_id) -- fa134
2621: AND awdv.award_status = 'ACCEPTED'
2622: AND awdv.fed_fund_code IN ('DLP','DLS','DLU','FLP','FLS','FLU','ALT','GPLUSFL')
2623: AND awdv.award_id NOT IN ( SELECT loans.award_id
2624: FROM igf_sl_loans_all loans )
2625: ORDER BY awdv.award_id;
2626:
2627: lv_isir_present BOOLEAN ;
2628:

Line 2632: ln_seq_number igf_sl_loans_all.seq_num%TYPE;

2628:
2629: lb_print_dl BOOLEAN;
2630: lb_print_cl BOOLEAN;
2631:
2632: ln_seq_number igf_sl_loans_all.seq_num%TYPE;
2633: l_msg_name fnd_new_messages.message_name%TYPE;
2634: l_aid NUMBER;
2635: l_loan_tab igf_aw_packng_subfns.std_loan_tab;
2636:

Line 2644: igf_sl_loans_all loan,

2640:
2641: CURSOR cur_count_fed_code IS
2642: SELECT COUNT(*) + 1
2643: FROM
2644: igf_sl_loans_all loan,
2645: igf_aw_award_all awd,
2646: igf_aw_fund_mast_all fmast,
2647: igf_aw_fund_cat_all fcat,
2648: igf_ap_fa_base_rec_all fabase

Line 2659: lv_loan_number igf_sl_loans_all.loan_number%TYPE;

2655: fabase.ci_sequence_number = award_rec.ci_sequence_number AND
2656: fabase.person_id = award_rec.student_id AND
2657: fcat.fed_fund_code = award_rec.fed_fund_code;
2658:
2659: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
2660:
2661: lv_row_id ROWID;
2662: ln_loan_id igf_sl_loans_all.loan_id%TYPE;
2663: l_head VARCHAR2(1);

Line 2662: ln_loan_id igf_sl_loans_all.loan_id%TYPE;

2658:
2659: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
2660:
2661: lv_row_id ROWID;
2662: ln_loan_id igf_sl_loans_all.loan_id%TYPE;
2663: l_head VARCHAR2(1);
2664: l_found_loans VARCHAR2(1);
2665: l_fund_type VARCHAR2(10);
2666:

Line 3162: lv_loan_number igf_sl_loans_all.loan_number%TYPE;

3158:
3159: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
3160: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
3161:
3162: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
3163:
3164: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
3165:
3166: lv_row_id ROWID;

Line 3164: lv_loan_status igf_sl_loans_all.loan_status%TYPE;

3160: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
3161:
3162: lv_loan_number igf_sl_loans_all.loan_number%TYPE;
3163:
3164: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
3165:
3166: lv_row_id ROWID;
3167: lv_incr_date NUMBER;
3168: l_found_loans VARCHAR2(1);