[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_cal_type = cp_v_fee_cal_type
AND inv.fee_ci_sequence_number = cp_n_fee_seq_number
AND inv.transaction_type NOT IN ('RETENTION','REFUND','AID_ADJ','WAIVER_ADJ','SPONSOR','PAY_PLAN');
SELECT inv.invoice_id, inv.invoice_amount
FROM igs_fi_inv_int_all inv,
igs_fi_fee_type_all ft
WHERE inv.person_id = cp_n_person_id
AND inv.fee_cal_type = cp_v_fee_cal_type
AND inv.fee_ci_sequence_number = cp_n_fee_seq_number
AND inv.transaction_type NOT IN ('RETENTION','REFUND','AID_ADJ','WAIVER_ADJ','SPONSOR','PAY_PLAN')
AND ft.fee_type = inv.fee_type
AND ft.fee_class = cp_v_fee_class;
SELECT inv.invoice_id, inv.invoice_amount
FROM igs_fi_inv_int_all inv,
igs_fi_fee_type_all ft
WHERE inv.person_id = cp_n_person_id
AND inv.fee_cal_type = cp_v_fee_cal_type
AND inv.fee_ci_sequence_number = cp_n_fee_seq_number
AND inv.transaction_type <> 'RETENTION'
AND inv.course_cd = cp_v_course_cd
AND ft.fee_type = inv.fee_type
AND ft.fee_class = cp_v_fee_class;
SELECT inv.invoice_id, inv.invoice_amount
FROM igs_fi_inv_int_all inv,
igs_fi_invln_int_all invln,
igs_fi_fee_type_all ft,
igs_ps_unit_ofr_opt_all uoo
WHERE inv.person_id = cp_n_person_id
AND inv.fee_cal_type = cp_v_fee_cal_type
AND inv.fee_ci_sequence_number =cp_n_fee_seq_number
AND inv.transaction_type <> 'RETENTION'
AND invln.invoice_id = inv.invoice_id
AND ft.fee_type = inv.fee_type
AND ft.fee_class = cp_v_fee_class
AND uoo.uoo_id = invln.uoo_id
AND uoo.unit_cd = cp_v_unit_cd
AND uoo.version_number = cp_n_unit_ver_num;
SELECT appl.amount_applied AS 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.application_type = 'APP'
AND crd.credit_id = appl.credit_id
AND crd.credit_type_id = cr.credit_type_id
AND cr.credit_class = 'CHGADJ';
SELECT igs_fi_gen_007.get_sum_appl_amnt (appl.application_id) amount_applied , application_id
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.application_type = 'APP'
AND crd.credit_id = appl.credit_id
AND crd.status = 'CLEARED'
AND crd.fee_cal_type = cp_v_fee_cal_type
AND crd.fee_ci_sequence_number = cp_n_fee_seq_number
AND crd.credit_type_id = cr.credit_type_id
AND cr.credit_class = 'WAIVER';
SELECT appl.amount_applied AS amount_applied, appl.credit_id as credit_id
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.application_type = 'APP'
AND crd.credit_id = appl.credit_id
AND crd.fee_cal_type = cp_v_fee_cal_type
AND crd.fee_ci_sequence_number = cp_n_fee_seq_number
AND crd.status = 'CLEARED'
AND crd.credit_type_id = cr.credit_type_id
AND cr.credit_class = 'SPNSP'
AND NOT EXISTS (
SELECT '1'
FROM igf_db_awd_disb_dtl_all disb_dtl
, igf_aw_awd_disb_all disb
, igf_aw_award_all awd
, igf_aw_fund_mast_all fmast
WHERE disb_dtl.sf_credit_id = crd.credit_id
AND disb.award_id = disb_dtl.award_id
AND disb.disb_num = disb_dtl.disb_num
AND disb.ld_cal_type = cp_v_ld_cal_type
AND disb.ld_sequence_number = cp_n_ld_seq_number
AND awd.award_id = disb.award_id
AND fmast.fund_id = awd.fund_id
AND fmast.fund_code = cp_v_fund_code
AND ROWNUM = 1
);
SELECT 'x'
FROM igs_en_su_attempt
WHERE person_id = cp_person_id
AND course_cd = cp_course_cd
AND unit_attempt_status IN ('ENROLLED', 'COMPLETED')
AND unit_cd = cp_unit_cd
AND version_number = cp_unit_version_number
AND (cal_type, ci_sequence_number) IN (SELECT teach_cal_type, teach_ci_sequence_number
FROM igs_ca_load_to_teach_v
WHERE load_cal_type = cp_ld_cal_type
AND load_ci_sequence_number = cp_ld_ci_sequence_number);