[Home] [Help]
291:
292: Known limitations,enhancements,remarks:
293: Change History
294: Who When What
295: skharida 26-Jun-2006 Bug 5208136 - Removed the obsoleted columns of the table IGS_FI_INV_INT_ALL
296: agairola 05-Aug-2005 Changes as per Waiver build: 3392095
297: ***************************************************************** */
298:
299: -- Cursor for selecting all the Charge records for the person and tax year.
299: -- Cursor for selecting all the Charge records for the person and tax year.
300: CURSOR cur_chg(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
301: cp_v_tax_year igs_fi_1098t_setup.tax_year_code%TYPE) IS
302: SELECT inv.rowid row_id, inv.*
303: FROM igs_fi_inv_int_all inv
304: WHERE person_id = cp_n_person_id
305: AND tax_year_code = cp_v_tax_year
306: FOR UPDATE OF tax_year_code NOWAIT;
307:
780: RETURN l_b_validate;
781: END validate_params;
782:
783: FUNCTION get_sys_fund_type(p_n_credit_id igs_fi_credits_all.credit_id%TYPE,
784: p_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) RETURN VARCHAR2 AS
785:
786: /******************************************************************
787: Created By : Amit Gairola
788: Date Created By : 06-May-2005
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:
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
933: inv.invoice_id
934: FROM igs_fi_credits_all crd,
935: igs_fi_cr_types_all crt,
936: igs_fi_1098t_fts fts,
937: igs_fi_inv_int_all inv,
938: igs_fi_applications app
939: WHERE crd.credit_type_id = crt.credit_type_id
940: AND crt.credit_class = 'CHGADJ'
941: AND crd.party_id = cp_n_person_id
954: cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
955: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
956: cp_d_start_date DATE) IS
957: SELECT 'x'
958: FROM igs_fi_inv_int_all inv,
959: igs_fi_1098t_setup stp
960: WHERE inv.person_id = cp_n_person_id
961: AND inv.fee_type = cp_v_fee_type
962: AND inv.fee_cal_type = cp_v_fee_cal_type
1171:
1172: Known limitations,enhancements,remarks:
1173: Change History
1174: Who When What
1175: skharida 26-Jun-2006 Bug 5208136 - Removed the obsoleted columns of the table IGS_FI_INV_INT_ALL
1176: agairola 05-Aug-2005 Changes as per Waiver build: 3392095
1177: ***************************************************************** */
1178: l_n_orig_chg NUMBER;
1179: l_n_adj_chg NUMBER;
1183: CURSOR cur_chg(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1184: cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1185: cp_d_end_date DATE) IS
1186: SELECT inv.*, inv.rowid row_id
1187: FROM igs_fi_inv_int_all inv,
1188: igs_fi_1098t_fts fts
1189: WHERE inv.fee_type = fts.fee_type
1190: AND inv.person_id = cp_n_person_id
1191: AND fts.tax_year_name = cp_v_tax_year_name
1208: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1209: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
1210: cp_d_start_date DATE) IS
1211: SELECT 'x'
1212: FROM igs_fi_inv_int_all inv,
1213: igs_fi_1098t_setup stp
1214: WHERE inv.person_id = cp_n_person_id
1215: AND inv.fee_type = cp_v_fee_type
1216: AND inv.fee_cal_type = cp_v_fee_cal_type
1651:
1652: Known limitations,enhancements,remarks:
1653: Change History
1654: Who When What
1655: skharida 26/06/06 Bug 5208136 - Removed the obsoleted columns of the table IGS_FI_INV_INT_ALL
1656: skharida 22/05/06 Bug 5213590 - Added changes to check for waiver name
1657: agairola 23/11/05 Bug:4747419 - Modified logic for Waiver Adjustment Charges
1658: agairola 05-Aug-2005 Changes as per Waiver build: 3392095
1659: ***************************************************************** */
1665: cp_d_end_date DATE) IS
1666: SELECT inv.rowid row_id,
1667: inv.*,
1668: ft.s_fee_type
1669: FROM igs_fi_inv_int_all inv,
1670: igs_fi_fee_type ft
1671: WHERE inv.person_id = cp_n_person_id
1672: AND ft.fee_type = inv.fee_type
1673: AND inv.tax_year_code IS NULL