APPS.IGF_SL_LAR_CREATION dependencies on IGF_AW_AWD_DISB

Line 158: gn_award_id igf_aw_awd_disb_all.award_id%TYPE;

154: gv_atd_entity_id_txt VARCHAR2(30);
155: gv_rep_entity_id_txt VARCHAR2(30);
156:
157: gv_unsub_elig_for_depnt igf_sl_lor.unsub_elig_for_depnt%TYPE;
158: gn_award_id igf_aw_awd_disb_all.award_id%TYPE;
159:
160: g_accepted_amt award_rec.accepted_amt%TYPE;
161:
162: g_process_log igf_lookups_view.meaning%TYPE;

Line 616: FROM igf_aw_awd_disb awd

612: -- Cursor to retrieve Loan Start Date
613: --
614: CURSOR cur_loan_start_dt ( p_award_id igf_aw_award_all.award_id%TYPE) IS
615: SELECT ld_cal_type,ld_sequence_number
616: FROM igf_aw_awd_disb awd
617: WHERE awd.award_id = p_award_id
618: AND awd.trans_type <> 'C'
619: GROUP BY awd.ld_cal_type,awd.ld_sequence_number;
620:

Line 676: FROM igf_aw_awd_disb awd

672: -- Cursor to Retrieve Loan End Date
673: --
674: CURSOR cur_loan_end_dt ( p_award_id igf_aw_award_all.award_id%TYPE) IS
675: SELECT ld_cal_type,ld_sequence_number
676: FROM igf_aw_awd_disb awd
677: WHERE awd.award_id = p_award_id
678: AND awd.trans_type <> 'C'
679: GROUP BY awd.ld_cal_type,awd.ld_sequence_number;
680:

Line 1578: CURSOR c_disb_count (cp_award_id igf_aw_awd_disb_all.award_id%TYPE) IS

1574: AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);
1575:
1576: c_clsetup_rec c_clsetup%ROWTYPE;
1577:
1578: CURSOR c_disb_count (cp_award_id igf_aw_awd_disb_all.award_id%TYPE) IS
1579: SELECT COUNT(*)
1580: FROM igf_aw_awd_disb_all
1581: WHERE award_id = cp_award_id;
1582:

Line 1580: FROM igf_aw_awd_disb_all

1576: c_clsetup_rec c_clsetup%ROWTYPE;
1577:
1578: CURSOR c_disb_count (cp_award_id igf_aw_awd_disb_all.award_id%TYPE) IS
1579: SELECT COUNT(*)
1580: FROM igf_aw_awd_disb_all
1581: WHERE award_id = cp_award_id;
1582:
1583: l_disb_count NUMBER;
1584: