APPS.IGF_AW_PACKAGING dependencies on IGF_SL_LOANS

Line 1318: FROM igf_sl_loans_all loan,

1314: cp_amount igf_aw_award_all.offered_amt%TYPE
1315: ) IS
1316: SELECT loan.ROWID row_id,
1317: loan.*
1318: FROM igf_sl_loans_all loan,
1319: igf_aw_award_all awd
1320: WHERE loan.award_id = cp_award_id
1321: AND loan.award_id = awd.award_id
1322: AND awd.offered_amt <> cp_amount

Line 1324: l_loan_status igf_sl_loans_all.loan_status%TYPE;

1320: WHERE loan.award_id = cp_award_id
1321: AND loan.award_id = awd.award_id
1322: AND awd.offered_amt <> cp_amount
1323: AND loan.loan_status <> 'S';
1324: l_loan_status igf_sl_loans_all.loan_status%TYPE;
1325:
1326: BEGIN
1327: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1328: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.update_loan_stat.debug '|| g_req_id,'starting update_loan_stat with award_id:'||p_award_id||

Line 1359: igf_sl_loans_pkg.update_row(

1355: l_loan.loan_status := 'G';
1356: l_loan.loan_status_date := TRUNC(SYSDATE);
1357: END IF;
1358:
1359: igf_sl_loans_pkg.update_row(
1360: x_rowid => l_loan.row_id,
1361: x_loan_id => l_loan.loan_id,
1362: x_award_id => l_loan.award_id,
1363: x_seq_num => l_loan.seq_num,

Line 4453: FROM igf_sl_loans

4449:
4450: -- Get loan status
4451: CURSOR c_loan IS
4452: SELECT 'x'
4453: FROM igf_sl_loans
4454: WHERE award_id = p_award_id
4455: AND loan_status NOT IN ('G','N');--ready to send and not ready to send
4456: l_loan c_loan%ROWTYPE;
4457:

Line 4951: FROM igf_sl_loans

4947: cp_award_id igf_aw_award_all.award_id%TYPE
4948: ) IS
4949: SELECT loan_status,
4950: loan_chg_status
4951: FROM igf_sl_loans
4952: WHERE award_id = cp_award_id;
4953: l_loan_status igf_sl_loans.loan_status%TYPE;
4954: l_loan_chg_status igf_sl_loans.loan_chg_status%TYPE;
4955:

Line 4953: l_loan_status igf_sl_loans.loan_status%TYPE;

4949: SELECT loan_status,
4950: loan_chg_status
4951: FROM igf_sl_loans
4952: WHERE award_id = cp_award_id;
4953: l_loan_status igf_sl_loans.loan_status%TYPE;
4954: l_loan_chg_status igf_sl_loans.loan_chg_status%TYPE;
4955:
4956: CURSOR c_pell_orig_stat(
4957: cp_award_id igf_aw_award_all.award_id%TYPE

Line 4954: l_loan_chg_status igf_sl_loans.loan_chg_status%TYPE;

4950: loan_chg_status
4951: FROM igf_sl_loans
4952: WHERE award_id = cp_award_id;
4953: l_loan_status igf_sl_loans.loan_status%TYPE;
4954: l_loan_chg_status igf_sl_loans.loan_chg_status%TYPE;
4955:
4956: CURSOR c_pell_orig_stat(
4957: cp_award_id igf_aw_award_all.award_id%TYPE
4958: ) IS