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

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||