APPS.IGF_SL_REL_DISB dependencies on IGF_SL_LOANS

Line 236: FUNCTION chk_loan_active(p_loan_id igf_sl_loans_all.loan_id%TYPE)

232: igs_ge_msg_stack.ADD;
233: app_exception.raise_exception;
234: END chk_fed_elig;
235:
236: FUNCTION chk_loan_active(p_loan_id igf_sl_loans_all.loan_id%TYPE)
237: RETURN BOOLEAN
238: AS
239: /*
240: || Created By : pssahni

Line 248: CURSOR cur_loan_active(p_loan_id igf_sl_loans_all.loan_id%TYPE)

244: || (reverse chronological order - newest change first)
245: */
246:
247: -- Get the details of loan status
248: CURSOR cur_loan_active(p_loan_id igf_sl_loans_all.loan_id%TYPE)
249: IS
250: SELECT active
251: FROM igf_sl_loans_all
252: WHERE loan_id = p_loan_id;

Line 251: FROM igf_sl_loans_all

247: -- Get the details of loan status
248: CURSOR cur_loan_active(p_loan_id igf_sl_loans_all.loan_id%TYPE)
249: IS
250: SELECT active
251: FROM igf_sl_loans_all
252: WHERE loan_id = p_loan_id;
253:
254: loan_active_rec cur_loan_active%ROWTYPE;
255: BEGIN

Line 790: FROM igf_sl_lor_all lor, igf_sl_loans_all loan

786:
787: CURSOR cur_get_crdt_status(p_award_id igf_aw_award_all.award_id%TYPE)
788: IS
789: SELECT lor.crdt_decision_status status, lor.credit_override override
790: FROM igf_sl_lor_all lor, igf_sl_loans_all loan
791: WHERE loan.loan_id = lor.loan_id AND loan.award_id = p_award_id;
792:
793: get_crdt_status_rec cur_get_crdt_status%ROWTYPE;
794: BEGIN

Line 1451: FUNCTION get_loan_num(p_loan_id igf_sl_loans_all.loan_id%TYPE)

1447: igs_ge_msg_stack.ADD;
1448: app_exception.raise_exception;
1449: END delete_pays;
1450:
1451: FUNCTION get_loan_num(p_loan_id igf_sl_loans_all.loan_id%TYPE)
1452: RETURN VARCHAR2
1453: AS
1454: /*
1455: || Created By : pssahni

Line 1465: CURSOR cur_get_loan_num(p_loan_id igf_sl_loans_all.loan_id%TYPE)

1461: || (reverse chronological order - newest change first)
1462: */
1463:
1464: -- Get loan number
1465: CURSOR cur_get_loan_num(p_loan_id igf_sl_loans_all.loan_id%TYPE)
1466: IS
1467: SELECT loan_number
1468: FROM igf_sl_loans
1469: WHERE p_loan_id = loan_id;

Line 1468: FROM igf_sl_loans

1464: -- Get loan number
1465: CURSOR cur_get_loan_num(p_loan_id igf_sl_loans_all.loan_id%TYPE)
1466: IS
1467: SELECT loan_number
1468: FROM igf_sl_loans
1469: WHERE p_loan_id = loan_id;
1470:
1471: get_loan_num_rec cur_get_loan_num%ROWTYPE;
1472: BEGIN

Line 1713: p_loan_id igf_sl_loans_all.loan_id%TYPE,

1709: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1710: p_result IN OUT NOCOPY VARCHAR2,
1711: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1712: p_award_id igf_aw_award_all.award_id%TYPE,
1713: p_loan_id igf_sl_loans_all.loan_id%TYPE,
1714: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE, p_trans_type VARCHAR2
1715: )
1716: AS
1717:

Line 1852: FROM igf_sl_loans_all

1848: -- Get the loan generated for this award
1849: CURSOR cur_get_loans(p_award_id NUMBER, p_loan_id NUMBER)
1850: IS
1851: SELECT loan_id, loan_number, loan_status, active, loan_chg_status
1852: FROM igf_sl_loans_all
1853: WHERE award_id = p_award_id AND loan_id = NVL(loan_id, p_loan_id);
1854:
1855: get_loans_rec cur_get_loans%ROWTYPE;
1856:

Line 3379: CURSOR cur_get_awd_id(p_loan_id igf_sl_loans_all.loan_id%TYPE)

3375:
3376:
3377: -- Cursor to get award_id from a loan_id
3378:
3379: CURSOR cur_get_awd_id(p_loan_id igf_sl_loans_all.loan_id%TYPE)
3380: IS
3381: SELECT award_id
3382: FROM igf_sl_loans_all
3383: WHERE loan_id = p_loan_id;

Line 3382: FROM igf_sl_loans_all

3378:
3379: CURSOR cur_get_awd_id(p_loan_id igf_sl_loans_all.loan_id%TYPE)
3380: IS
3381: SELECT award_id
3382: FROM igf_sl_loans_all
3383: WHERE loan_id = p_loan_id;
3384:
3385: get_awd_id_rec cur_get_awd_id%ROWTYPE;
3386: