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_DL_LI_IMP_PKG dependencies on IGF_DB_AWD_DISB_DTL_ALL

Line 689: FROM igf_db_awd_disb_dtl_all

685: cp_disb_num NUMBER,
686: cp_disb_seq_num NUMBER )
687: IS
688: SELECT disb_gross_amt
689: FROM igf_db_awd_disb_dtl_all
690: WHERE award_id = cp_award_id
691: AND disb_num = cp_disb_num
692: AND disb_seq_num = cp_disb_seq_num;
693:

Line 2591: FROM IGF_DB_AWD_DISB_DTL_ALL adisb

2587: CURSOR c_disb_det (cp_disb_num NUMBER,
2588: cp_DISBURSEMENT_SEQ_NUM VARCHAR2)
2589: IS
2590: SELECT ROWID,adisb.*
2591: FROM IGF_DB_AWD_DISB_DTL_ALL adisb
2592: WHERE adisb.award_id = p_award_id
2593: AND adisb.disb_num = cp_disb_num
2594: AND adisb.disb_seq_num = cp_disbursement_seq_num;
2595: l_rec_disb_dtl c_disb_det%ROWTYPE;

Line 2597: l_disb_status igf_db_awd_disb_dtl_all.disb_status%TYPE;

2593: AND adisb.disb_num = cp_disb_num
2594: AND adisb.disb_seq_num = cp_disbursement_seq_num;
2595: l_rec_disb_dtl c_disb_det%ROWTYPE;
2596:
2597: l_disb_status igf_db_awd_disb_dtl_all.disb_status%TYPE;
2598: BEGIN
2599:
2600: ln_rowid := NULL;
2601: ln_ddrp_id := NULL;

Line 3242: FROM igf_db_awd_disb_dtl_all adisb

3238: cp_disb_num NUMBER,
3239: cp_disb_seq_num NUMBER)
3240: IS
3241: SELECT 1
3242: FROM igf_db_awd_disb_dtl_all adisb
3243: WHERE adisb.award_id = cp_award_id
3244: AND adisb.disb_num = cp_disb_num
3245: AND adisb.disb_seq_num = cp_disb_seq_num;
3246:

Line 3300: FROM igf_db_awd_disb_dtl_all adisb

3296: cp_loan_number VARCHAR2)
3297: IS
3298: SELECT disb_num,
3299: disb_seq_num
3300: FROM igf_db_awd_disb_dtl_all adisb
3301: WHERE adisb.award_id = cp_award_id
3302: AND (disb_num,disb_seq_num) NOT IN
3303: (
3304: SELECT disbursement_num,disbursement_seq_num