APPS.IGF_GR_GEN dependencies on IGF_AW_AWD_DISB

Line 167: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

163: END get_cycle_year;
164:
165:
166: FUNCTION disb_has_adj ( p_award_id igf_aw_award_all.award_id%TYPE,
167: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
168: RETURN BOOLEAN
169: IS
170:
171: --------------------------------------------------------------------------------------------

Line 176: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

172: --
173: --------------------------------------------------------------------------------------------
174:
175: CURSOR cur_get_adj ( p_award_id igf_aw_award_all.award_id%TYPE,
176: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
177: IS
178: SELECT
179: COUNT (disb_num)
180: FROM

Line 486: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,

482: END get_per_num_oss;
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: --

Line 499: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

495: --
496: --------------------------------------------------------------------------------------------
497:
498: CURSOR cur_get_adisb ( p_award_id igf_aw_award_all.award_id%TYPE,
499: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
500: IS
501: SELECT
502: awd.award_id,awd.disb_num
503: FROM

Line 504: igf_aw_awd_disb awd

500: IS
501: SELECT
502: awd.award_id,awd.disb_num
503: FROM
504: igf_aw_awd_disb awd
505: WHERE
506: awd.award_id = p_award_id AND
507: awd.disb_num = NVL(p_disb_num,awd.disb_num) AND
508: awd.trans_type = 'P';

Line 515: CURSOR cur_chk_holds ( p_award_id igf_aw_awd_disb_all.award_id%TYPE,

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

Line 516: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,

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

Line 1274: igf_aw_awd_disb

1270: IS
1271: SELECT
1272: MIN(disb_num)
1273: FROM
1274: igf_aw_awd_disb
1275: WHERE
1276: award_id = p_award_id;
1277:
1278: ln_min_num NUMBER(10);

Line 2966: igf_aw_awd_disb

2962: IS
2963: SELECT
2964: MIN(disb_num)
2965: FROM
2966: igf_aw_awd_disb
2967: WHERE
2968: award_id = p_award_id;
2969:
2970: ln_min_num igf_aw_awd_disb_all.disb_num%TYPE;

Line 2970: ln_min_num igf_aw_awd_disb_all.disb_num%TYPE;

2966: igf_aw_awd_disb
2967: WHERE
2968: award_id = p_award_id;
2969:
2970: ln_min_num igf_aw_awd_disb_all.disb_num%TYPE;
2971:
2972: BEGIN
2973:
2974: OPEN cur_min_disb ( p_award_id );