APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGF_DB_AWD_DISB_DTL_ALL

Line 798: FROM igf_db_awd_disb_dtl_all disb,

794: ***************************************************************** */
795:
796: CURSOR cur_fund_id_crd(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
797: SELECT awd.fund_id
798: FROM igf_db_awd_disb_dtl_all disb,
799: igf_aw_award_all awd
800: WHERE awd.award_id = disb.award_id
801: AND disb.sf_credit_id = cp_n_credit_id;
802:

Line 805: FROM igf_db_awd_disb_dtl_all disb,

801: AND disb.sf_credit_id = cp_n_credit_id;
802:
803: CURSOR cur_fund_id_inv(cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
804: SELECT awd.fund_id
805: FROM igf_db_awd_disb_dtl_all disb,
806: igf_aw_award_all awd
807: WHERE awd.award_id = disb.award_id
808: AND disb.sf_invoice_num = cp_n_invoice_id;
809:

Line 1436: FROM igf_db_awd_disb_dtl_all

1432: AND crd.tax_year_code IS NULL;
1433:
1434: CURSOR cur_chk_adj(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
1435: SELECT 'x'
1436: FROM igf_db_awd_disb_dtl_all
1437: WHERE spnsr_credit_id = cp_n_credit_id;
1438:
1439: CURSOR cur_chk_orig_credit(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1440: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,