APPS.IGF_SP_AWARD dependencies on IGF_AW_AWARD_ALL

Line 348: PROCEDURE create_disb_dtl(p_award_id igf_aw_award_all.award_id%TYPE,

344: END IF;
345: RETURN TRUE;
346: END check_eligibility;
347:
348: PROCEDURE create_disb_dtl(p_award_id igf_aw_award_all.award_id%TYPE,
349: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
350: AS
351: -------------------------------------------------------------------------------------
352: --Created by : smanglm ( Oracle IDC)

Line 368: CURSOR cur_chk_adj( cp_award_id igf_aw_award_all.award_id%TYPE,

364: -- are now rounded off to currency precision
365: --vvutukur 26-Feb-2003 Enh#2758823.FA117 Build. Assigned value 'D' to disb_dtl_rec.disb_activity, instead of NULL.
366: -------------------------------------------------------------------------------------
367:
368: CURSOR cur_chk_adj( cp_award_id igf_aw_award_all.award_id%TYPE,
369: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
370: IS
371: SELECT NVL(disb_seq_num,0) disb_seq_num
372: FROM igf_db_awd_disb_dtl

Line 377: CURSOR cur_get_adisb( cp_award_id igf_aw_award_all.award_id%TYPE,

373: WHERE award_id = cp_award_id AND
374: disb_num = cp_disb_num;
375: chk_adj_rec cur_chk_adj%ROWTYPE;
376:
377: CURSOR cur_get_adisb( cp_award_id igf_aw_award_all.award_id%TYPE,
378: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
379: IS
380: SELECT *
381: FROM igf_aw_awd_disb