[Home] [Help]
721: cp_unapp_type VARCHAR2) IS
722: SELECT appl.application_id
723: FROM igs_fi_applications appl,
724: igs_fi_credits fc,
725: igs_fi_cr_types crt
726: WHERE appl.invoice_id = cp_invoice_id
727: AND appl.credit_id = fc.credit_id
728: AND fc.credit_type_id = crt.credit_type_id
729: AND crt.credit_class <> cp_credit_class
739: -- based on the Sub Account and the Negative Charges Credit Class
740: CURSOR cur_crt(cp_neg_credit_class VARCHAR2,
741: cp_effective_date DATE) IS
742: SELECT credit_type_id
743: FROM igs_fi_cr_types
744: WHERE credit_class = cp_neg_credit_class
745: AND cp_effective_date BETWEEN effective_start_date AND NVL(effective_end_date,
746: cp_effective_date);
747:
1110: OR (inv.course_cd IS NULL and cp_course_cd IS NULL)))
1111: OR (inv.invoice_id = cp_invoice_id))
1112: AND NOT EXISTS (SELECT 'x'
1113: FROM igs_fi_credits fc,
1114: igs_fi_cr_types crt,
1115: igs_fi_applications app
1116: WHERE app.invoice_id = inv.invoice_id
1117: AND app.credit_id = fc.credit_id
1118: AND fc.status = g_cleared
1529: -- Cursor to fetch sum of all negative adjustment credits for a given invoice_id
1530: CURSOR cur_chgadj(cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
1531: SELECT SUM(amount_applied)
1532: FROM igs_fi_credits fc,
1533: igs_fi_cr_types crt,
1534: igs_fi_applications app
1535: WHERE app.invoice_id = cp_invoice_id
1536: AND app.credit_id = fc.credit_id
1537: AND fc.status = g_cleared
2574: CURSOR cur_chk_adj(cp_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
2575: cp_inv_amt igs_fi_inv_int_all.invoice_amount%TYPE) IS
2576: SELECT 'x'
2577: FROM igs_fi_credits_all fc,
2578: igs_fi_cr_types_all crt,
2579: igs_fi_applications app
2580: WHERE app.invoice_id = cp_invoice_id
2581: AND app.credit_id = fc.credit_id
2582: AND fc.status = g_cleared