[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT inv.invoice_id, inv.invoice_amount
FROM igs_fi_inv_int_all inv
WHERE inv.person_id = cp_n_person_id
AND inv.fee_type = cp_v_target_fee_type
AND inv.fee_cal_type = cp_v_fee_cal_type
AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND inv.transaction_type <> 'RETENTION'
AND (cp_n_invoice_id IS NULL OR inv.invoice_id = cp_n_invoice_id)
ORDER BY inv.invoice_id;
SELECT appl.amount_applied
FROM igs_fi_applications appl,
igs_fi_credits_all crd,
igs_fi_cr_types_all cr
WHERE appl.invoice_id = cp_n_invoice_id
AND appl.credit_id = crd.credit_id
AND appl.application_type = 'APP'
AND crd.credit_type_id = cr.credit_type_id
AND cr.credit_class = 'CHGADJ';
SELECT
appl.amount_applied,
appl.application_id,
appl.credit_id,
appl.invoice_id
FROM igs_fi_inv_int_all inv,
igs_fi_applications appl,
igs_fi_credits_all crd,
igs_fi_cr_types cr
WHERE inv.person_id = cp_n_person_id
AND inv.fee_type = cp_v_target_fee_type
AND inv.fee_cal_type = cp_v_fee_cal_type
AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND (cp_n_invoice_id IS NULL OR inv.invoice_id = cp_n_invoice_id)
AND appl.invoice_id = inv.invoice_id
AND appl.credit_id = crd.credit_id
AND appl.application_type = 'APP'
AND crd.fee_cal_type = cp_v_fee_cal_type
AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND (cp_v_waiver_name IS NULL OR crd.waiver_name <> cp_v_waiver_name)
AND crd.status = 'CLEARED'
AND crd.credit_type_id = cr.credit_type_id
AND cr.credit_class = 'WAIVER'
ORDER BY appl.application_id;
SELECT appl.amount_applied
FROM igs_fi_applications appl,
igs_fi_inv_int_all inv
WHERE appl.credit_id = cp_n_credit_id
AND appl.invoice_id = inv.invoice_id
AND appl.application_type = 'APP'
AND inv.fee_cal_type = cp_v_fee_cal_type
AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND inv.transaction_type = 'WAIVER_ADJ'
AND EXISTS( SELECT '1'
FROM igs_fi_credits_all crd,
igs_fi_applications unappl
WHERE crd.credit_id = appl.credit_id
AND unappl.credit_id = crd.credit_id
AND unappl.invoice_id = cp_n_invoice_id
AND unappl.application_type = 'UNAPP'
AND unappl.amount_applied = - appl.amount_applied );
SELECT crd.credit_id,
crd.unapplied_amount
FROM igs_fi_credits_all crd
WHERE crd.credit_id = cp_credit_id
AND NVL(crd.unapplied_amount, 0) > 0;
SELECT crd.credit_id,
crd.unapplied_amount
FROM igs_fi_credits_all crd
WHERE (cp_credit_id IS NULL OR crd.credit_id = cp_credit_id)
AND crd.party_id = cp_n_person_id
AND crd.fee_cal_type = cp_v_fee_cal_type
AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND crd.waiver_name = cp_v_waiver_name
AND NVL(crd.unapplied_amount, 0) > 0 ;
SELECT inv.invoice_id,
inv.invoice_amount_due
FROM igs_fi_inv_int_all inv,
igs_fi_invln_int_all invln
WHERE inv.person_id = cp_n_person_id
AND inv.fee_type = cp_v_target_fee_type
AND inv.fee_cal_type = cp_v_fee_cal_type
AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND inv.transaction_type NOT IN ('RETENTION','WAIVER_ADJ')
AND invln.invoice_id = inv.invoice_id
AND NVL(invln.error_account,'N') = 'N'
ORDER BY inv.invoice_id;
SELECT inv.invoice_id,
inv.invoice_amount_due
FROM igs_fi_inv_int_all inv,
igs_fi_invln_int_all invln
WHERE inv.person_id = cp_n_person_id
AND inv.fee_type = cp_v_adj_fee_type
AND inv.fee_cal_type = cp_v_fee_cal_type
AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND inv.waiver_name = cp_v_waiver_name
AND NVL(inv.invoice_amount_due, 0) > 0
AND invln.invoice_id = inv.invoice_id
AND NVL(invln.error_account,'N') = 'N'
ORDER BY inv.invoice_id;
SELECT inv.invoice_id,
inv.invoice_amount_due
FROM igs_fi_inv_int_all inv,
igs_fi_invln_int_all invln
WHERE (inv.invoice_id = cp_n_invoice_id OR cp_n_invoice_id IS NULL)
AND inv.person_id = cp_n_person_id
AND inv.fee_type = cp_v_target_fee_type
AND inv.fee_cal_type = cp_v_fee_cal_type
AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND NVL (inv.invoice_amount_due, 0) > 0
AND inv.transaction_type <> 'RETENTION'
AND invln.invoice_id = inv.invoice_id
AND NVL(invln.error_account,'N') = 'N'
ORDER BY inv.invoice_id;
SELECT igs_fi_gen_007.get_sum_appl_amnt(appl.application_id) amount_applied,
appl.application_id,
appl.credit_id,
appl.invoice_id
FROM igs_fi_applications appl,
igs_fi_credits_all crd,
igs_fi_cr_types cr
WHERE appl.invoice_id = cp_n_invoice_id
AND appl.credit_id = crd.credit_id
AND appl.application_type = cp_cst_app
AND crd.credit_type_id = cr.credit_type_id
AND cr.credit_class NOT IN ('CHGADJ','WAIVER','ENRDEPOSIT','OTHDEPOSIT')
AND NOT EXISTS(
SELECT 'X'
FROM igs_fi_applications appl2
WHERE appl2.application_type = 'UNAPP'
AND appl2.link_application_id = appl.application_id
AND appl2.amount_applied = - appl.amount_applied)
ORDER BY appl.application_id;
SELECT
inv.invoice_id,
inv.invoice_amount,
inv.invoice_amount_due
FROM igs_fi_inv_int_all inv,
igs_fi_invln_int_all invln
WHERE inv.person_id = cp_n_person_id
AND inv.fee_type = cp_v_adj_fee_type
AND inv.fee_cal_type = cp_v_fee_cal_type
AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND inv.waiver_name = cp_v_waiver_name
AND NVL (inv.invoice_amount_due, 0) > 0
AND invln.invoice_id = inv.invoice_id
AND NVL(invln.error_account,'N') = 'N'
ORDER BY inv.invoice_id;
SELECT
crd.credit_id,
crd.unapplied_amount
FROM igs_fi_credits_all crd
WHERE (cp_n_credit_id IS NULL OR crd.credit_id = cp_n_credit_id)
AND crd.party_id = cp_n_person_id
AND crd.fee_cal_type = cp_v_fee_cal_type
AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND crd.waiver_name = cp_v_waiver_name
AND NVL(crd.unapplied_amount, 0) > 0
ORDER BY credit_id;
SELECT
crd.credit_id,
crd.unapplied_amount
FROM igs_fi_credits_all crd
WHERE (cp_n_credit_id IS NULL OR crd.credit_id = cp_n_credit_id)
AND crd.party_id = cp_n_person_id
AND crd.fee_cal_type = cp_v_fee_cal_type
AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq_num
AND crd.waiver_name = cp_v_waiver_name
ORDER BY credit_id;
SELECT
igs_fi_gen_007.get_sum_appl_amnt(appl.application_id) amount_applied,
appl.application_id,
appl.credit_id,
appl.invoice_id
FROM igs_fi_applications appl,
igs_fi_inv_int_all inv
WHERE appl.credit_id = cp_n_credit_id
AND appl.invoice_id = inv.invoice_id
AND appl.application_type = 'APP'
AND inv.transaction_type <> 'WAIVER_ADJ'
AND NOT EXISTS (
SELECT 'X'
FROM igs_fi_applications appl2
WHERE appl2.application_type = 'UNAPP'
AND appl2.link_application_id = appl.application_id
AND appl2.amount_applied = - appl.amount_applied)
ORDER BY appl.application_id;
SELECT waiver_notify_finaid_flag
FROM igs_fi_control_all;