APPS.IGF_SL_DL_RECORD dependencies on IGF_AW_AWARD

Line 230: p_award_id igf_aw_award.award_id%TYPE)

226: END DLTrailer_cur;
227:
228:
229: FUNCTION DLDisbDetails(p_dl_version igf_lookups_view.lookup_code%TYPE,
230: p_award_id igf_aw_award.award_id%TYPE)
231: RETURN VARCHAR2
232: AS
233: /*************************************************************
234: Created By : venagara

Line 254: FROM igf_aw_award awd,

250: CURSOR cur_disb IS
251: SELECT adisb.disb_date, NVL(adisb.disb_accepted_amt,adisb.disb_gross_amt) disb_gross_amt, adisb.fee_1,
252: adisb.int_rebate_amt interest_rebate,
253: adisb.disb_net_amt
254: FROM igf_aw_award awd,
255: igf_aw_awd_disb adisb,
256: igf_aw_fund_mast fmast,
257: igf_aw_fund_cat fcat,
258: igf_ap_fa_base_rec fabase

Line 320: FROM igf_ap_fa_base_rec fa, igf_sl_loans loan , igf_aw_award awd

316: -- We need person id to get primary enrol prog from FA Base History
317: CURSOR c_get_person_id ( cp_loan_number igf_sl_loans.loan_number%TYPE) IS
318: SELECT fa.person_id,
319: fa.base_id
320: FROM igf_ap_fa_base_rec fa, igf_sl_loans loan , igf_aw_award awd
321: WHERE fa.base_id = awd.base_id
322: AND awd.award_id = loan.award_id
323: AND loan.loan_number = cp_loan_number ;
324:

Line 525: igf_aw_award awd,

521: isr.dependency_status
522: FROM
523: igf_sl_loans loans,
524: igf_sl_lor lor,
525: igf_aw_award awd,
526: igf_aw_fund_mast fmast,
527: igf_aw_fund_cat fcat,
528: igf_ap_fa_base_rec fabase,
529: igf_ap_isir_matched isr