APPS.IGF_SL_LAR_CREATION dependencies on IGF_AW_AWD_DISB_ALL

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