APPS.IGF_GR_REPACKAGE dependencies on IGF_AW_AWD_DISB_ALL

Line 181: FROM igf_aw_awd_disb_all disb

177: cp_award_id igf_aw_award_all.award_id%TYPE
178: ) IS
179: SELECT disb.rowid row_id,
180: disb.*
181: FROM igf_aw_awd_disb_all disb
182: WHERE award_id = cp_award_id;
183:
184:
185:

Line 455: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

451:
452: -- Get disbursements which should be cancelled
453: CURSOR c_disb_cancel(
454: cp_award_id igf_aw_award_all.award_id%TYPE,
455: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
456: ) IS
457: SELECT *
458: FROM igf_aw_awd_disb
459: WHERE award_id = cp_award_id

Line 465: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE

461:
462: -- Get context disbursement record
463: CURSOR c_disb(
464: cp_award_id igf_aw_award_all.award_id%TYPE,
465: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
466: ) IS
467: SELECT disb.rowid row_id,
468: disb.*
469: FROM igf_aw_awd_disb_all disb

Line 469: FROM igf_aw_awd_disb_all disb

465: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
466: ) IS
467: SELECT disb.rowid row_id,
468: disb.*
469: FROM igf_aw_awd_disb_all disb
470: WHERE
471: award_id = cp_award_id AND
472: disb_num = cp_disb_num ;
473: