APPS.IGF_SL_CL_ORIG dependencies on IGF_SL_LOANS_ALL

Line 338: FROM igf_sl_loans_all loans,

334: lor.override_grade_level_code,
335: recip.relationship_cd,
336: lor.b_alien_reg_num_txt, -- fa 161 - bug # 5006583
337: lor.esign_src_typ_cd
338: FROM igf_sl_loans_all loans,
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,

Line 372: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,

368: retcode OUT NOCOPY NUMBER,
369: p_award_year IN VARCHAR2,
370: p_base_id IN VARCHAR2,
371: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
372: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
373: p_org_id IN NUMBER,
374: p_media_type IN VARCHAR2,
375: p_recipient_id IN VARCHAR2,
376: p_school_id IN VARCHAR2,

Line 1003: CURSOR c_sl_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS

999: SELECT igf_sl_lor.*
1000: FROM igf_sl_lor
1001: WHERE origination_id = p_origination_id FOR UPDATE OF sch_cert_date NOWAIT;
1002:
1003: CURSOR c_sl_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
1004: SELECT external_loan_id_txt
1005: FROM igf_sl_loans_all
1006: WHERE loan_id = cp_n_loan_id;
1007:

Line 1005: FROM igf_sl_loans_all

1001: WHERE origination_id = p_origination_id FOR UPDATE OF sch_cert_date NOWAIT;
1002:
1003: CURSOR c_sl_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
1004: SELECT external_loan_id_txt
1005: FROM igf_sl_loans_all
1006: WHERE loan_id = cp_n_loan_id;
1007:
1008: l_v_ext_loan_id_txt igf_sl_loans_all.external_loan_id_txt%TYPE;
1009:

Line 1008: l_v_ext_loan_id_txt igf_sl_loans_all.external_loan_id_txt%TYPE;

1004: SELECT external_loan_id_txt
1005: FROM igf_sl_loans_all
1006: WHERE loan_id = cp_n_loan_id;
1007:
1008: l_v_ext_loan_id_txt igf_sl_loans_all.external_loan_id_txt%TYPE;
1009:
1010: BEGIN
1011:
1012: FOR tbh_rec in c_tbh_cur LOOP

Line 1202: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,

1198: PROCEDURE sub_cl_originate( errbuf OUT NOCOPY VARCHAR2,
1199: retcode OUT NOCOPY NUMBER,
1200: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
1201: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
1202: p_loan_number IN igf_sl_loans_all.loan_number%TYPE,
1203: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
1204: p_org_id IN NUMBER,
1205: p_relationship_cd IN VARCHAR2,
1206: p_media_type IN VARCHAR2,

Line 1429: CURSOR c_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS

1425: FROM igf_aw_awd_disb
1426: WHERE award_id = p_award_id;
1427:
1428:
1429: CURSOR c_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
1430: SELECT lor.*
1431: FROM igf_sl_lor_all lor
1432: WHERE loan_id = cp_n_loan_id;
1433: