APPS.IGF_GR_GEN dependencies on IGF_DB_DISB_HOLDS_ALL

Line 487: p_hold igf_db_disb_holds_all.hold%TYPE)

483:
484:
485: PROCEDURE insert_sys_holds ( p_award_id igf_aw_award_all.award_id%TYPE,
486: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,
487: p_hold igf_db_disb_holds_all.hold%TYPE)
488: IS
489: --------------------------------------------------------------------------------------------
490: --
491: -- sjadhav, 15Feb2002

Line 511: holds_rec igf_db_disb_holds_all%ROWTYPE;

507: awd.disb_num = NVL(p_disb_num,awd.disb_num) AND
508: awd.trans_type = 'P';
509:
510: awd_rec cur_get_adisb%ROWTYPE;
511: holds_rec igf_db_disb_holds_all%ROWTYPE;
512:
513: lv_rowid ROWID;
514:
515: CURSOR cur_chk_holds ( p_award_id igf_aw_awd_disb_all.award_id%TYPE,

Line 517: p_hold igf_db_disb_holds_all.hold%TYPE)

513: lv_rowid ROWID;
514:
515: CURSOR cur_chk_holds ( p_award_id igf_aw_awd_disb_all.award_id%TYPE,
516: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,
517: p_hold igf_db_disb_holds_all.hold%TYPE)
518: IS
519: SELECT COUNT(hold_id) cnt
520: FROM
521: igf_db_disb_holds