APPS.IGF_SL_DL_CHG_ACK dependencies on IGF_SL_DL_CHG_FLD

Line 383: p_loan_catg igf_sl_dl_chg_fld.loan_catg%TYPE

379: --Check if the received file has the change code as LOAN_AMT_ACCEPTED
380: --for the particular Loan Number
381: CURSOR cur_get_loan_accp_amt(p_loan_number igf_sl_loans_all.loan_number%TYPE,
382: p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
383: p_loan_catg igf_sl_dl_chg_fld.loan_catg%TYPE
384: ) IS
385: SELECT resp.new_value
386: FROM igf_sl_dl_chg_resp resp,igf_sl_dl_chg_fld chgfld
387: WHERE loan_number =p_loan_number

Line 386: FROM igf_sl_dl_chg_resp resp,igf_sl_dl_chg_fld chgfld

382: p_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
383: p_loan_catg igf_sl_dl_chg_fld.loan_catg%TYPE
384: ) IS
385: SELECT resp.new_value
386: FROM igf_sl_dl_chg_resp resp,igf_sl_dl_chg_fld chgfld
387: WHERE loan_number =p_loan_number
388: AND dbth_id =p_dbth_id
389: AND status ='N'
390: AND resp.chg_code = chgfld.chg_code

Line 398: l_loan_catg igf_sl_dl_chg_fld.loan_catg%TYPE;

394:
395:
396: l_loan_accp_amt igf_aw_award_all.accepted_amt%TYPE;
397: l_loan_status igf_sl_loans_all.loan_status%TYPE;
398: l_loan_catg igf_sl_dl_chg_fld.loan_catg%TYPE;
399: l_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
400:
401: BEGIN
402:

Line 434: --The field name and corr Change Code are present in IGF_SL_DL_CHG_FLD

430: END IF;
431:
432: --Fetch the Response data for the particular loan number
433: --for which the CHANGE CODE Field Name is LOAN_ACCEPTED_AMT
434: --The field name and corr Change Code are present in IGF_SL_DL_CHG_FLD
435: --for the current loan category and also the file format version
436: --Seeded Data should be available
437:
438: OPEN cur_get_loan_accp_amt(resp_rec.loan_number,l_dbth_id,l_loan_catg);

Line 502: igf_sl_dl_chg_fld_v cchgv

498: CURSOR cur_chg_rej_resp(l_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
499: l_loan_number igf_sl_loans.loan_number%TYPE) IS
500: SELECT fld_name, cchgv.description fld_desc, rchg.reject_code, rchg.new_value
501: FROM igf_sl_dl_chg_resp rchg,
502: igf_sl_dl_chg_fld_v cchgv
503: WHERE rchg.dbth_id = l_dbth_id
504: AND rchg.loan_number = l_loan_number
505: AND rchg.reject_code IS NOT NULL
506: AND rchg.status = 'N'