[Home] [Help]
74: --sarakshi 18-Mar-2002 Bug:2144600, added logic for refunding the excess credit amount in
75: -- main_disbursement program unit
76: --vchappid 11-Feb-2002 Enh#2191470,modified cursor cur_disb, to include igf_aw_awd_disb table and
77: -- disb_dlt.ld_cal_type, disb_dlt.ld_sequence_number are included in the
78: -- cursor selected columns, removed reference to igf_aw_fund_tp_all and the where
79: -- clause is changed from tp_cal_type, tp_sequence_number to
80: -- disb_dlt.ld_cal_type, disb_dlt.ld_sequence_number
81: --
82: -------------------------------------------------------------------
87: CURSOR cur_disb(cp_cal_type igf_aw_fund_mast_v.ci_cal_type%TYPE,
88: cp_sequence_number igf_aw_fund_mast_v.ci_sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast_v.fund_id%TYPE,
90: cp_person_id igf_aw_award_v.person_id%TYPE,
91: cp_tp_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
92: cp_tp_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE,
93: cp_manage_accounts igs_fi_control_all.manage_accounts%TYPE
94: ) IS
95: SELECT disb_dlt.award_id,disb_dlt.disb_num,disb_dlt.disb_seq_num,disb_dlt.disb_date,
88: cp_sequence_number igf_aw_fund_mast_v.ci_sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast_v.fund_id%TYPE,
90: cp_person_id igf_aw_award_v.person_id%TYPE,
91: cp_tp_cal_type igf_aw_fund_tp.tp_cal_type%TYPE,
92: cp_tp_sequence_number igf_aw_fund_tp.tp_sequence_number%TYPE,
93: cp_manage_accounts igs_fi_control_all.manage_accounts%TYPE
94: ) IS
95: SELECT disb_dlt.award_id,disb_dlt.disb_num,disb_dlt.disb_seq_num,disb_dlt.disb_date,
96: fab.person_id,fcat.fed_fund_code fed_fund_code,fnd.fee_type,fnd.party_id,fnd.spnsr_fee_type,