APPS.IGS_FI_WAIVERS_API_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 42

  SELECT  fwp.fee_cal_type
         ,fwp.fee_ci_sequence_number
         ,fwp.waiver_name
         ,fwp.waiver_method_code
         ,fwp.waiver_status_code
         ,fwp.credit_type_id
         ,fwp.target_fee_type
         ,fwp.adjustment_fee_type
         ,fwp.waiver_mode_code
  FROM    igs_fi_waiver_pgms fwp
  WHERE   fwp.fee_cal_type           =  cp_v_fee_cal_type
  AND     fwp.fee_ci_sequence_number =  cp_n_fee_sequence_number
  AND     fwp.waiver_name            =  cp_v_waiver_name;

Line: 515

  SELECT  crd.fee_cal_type
         ,crd.fee_ci_sequence_number
         ,crd.waiver_name
         ,crd.credit_id
         ,crd.status
         ,crd.amount
         ,crd.unapplied_amount
  FROM    igs_fi_credits_all crd
  WHERE   crd.credit_id              = cp_n_credit_id
  AND     crd.fee_cal_type           = cp_v_fee_cal_type
  AND     crd.fee_ci_sequence_number = cp_n_fee_sequence_number
  AND     crd.waiver_name            = cp_v_waiver_name;

Line: 536

  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_sequence_number
  AND      inv.waiver_name            = cp_v_waiver_name
  AND      inv.transaction_type       = 'WAIVER_ADJ';