APPS.IGS_FI_PRC_WAIVERS SQL Statements

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

Line: 63

      SELECT waiver_name
      FROM   igs_fi_waiver_pgms
      WHERE  target_fee_type = cp_v_fee_type
      AND    fee_cal_type    = cp_v_fee_cal_type
      AND    fee_ci_sequence_number = cp_n_fee_ci_seq
      AND    ((waiver_name = cp_v_waiver_name) OR (cp_v_waiver_name IS NULL));

Line: 129

      SELECT crd.amount,
             crd.credit_id
      FROM   igs_fi_credits_all crd
      WHERE  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
      AND    crd.waiver_name = cp_v_waiver_name;

Line: 141

      SELECT SUM(appl.amount_applied) amt_appl
      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    inv.fee_cal_type = cp_v_fee_cal_type
      AND    inv.fee_ci_sequence_number = cp_n_fee_ci_seq
      AND    inv.waiver_name = cp_v_waiver_name
      AND    appl.application_type = 'APP'
      AND    inv.transaction_type = 'WAIVER_ADJ';

Line: 280

      SELECT inv.invoice_amount,
             inv.invoice_id
      FROM   igs_fi_inv_int_all inv
      WHERE  inv.person_id = cp_n_person_id
      AND    inv.fee_type  = cp_v_fee_type
      AND    inv.fee_cal_type = cp_v_fee_cal_type
      AND    inv.fee_ci_sequence_number = cp_n_fee_ci_seq
      AND    inv.transaction_type <> 'RETENTION'
      ORDER BY inv.invoice_id;

Line: 291

      SELECT SUM(appl.amount_applied) amt_appl
      FROM   igs_fi_applications appl,
             igs_fi_credits_all crd,
             igs_fi_cr_types crt
      WHERE  appl.invoice_id = cp_n_invoice_id
      AND    appl.credit_id = crd.credit_id
      AND    crd.credit_type_id = crt.credit_type_id
      AND    crt.credit_class = 'CHGADJ';

Line: 303

      SELECT fwpp.sup_waiver_name
      FROM   igs_fi_wav_pr_preqs fwpp
      WHERE  fwpp.fee_cal_type  = cp_v_fee_cal_type
      AND    fwpp.fee_ci_sequence_number = cp_n_fee_ci_seq
      AND    fwpp.sub_waiver_name = cp_v_waiver_name;

Line: 313

      SELECT appl.amount_applied,
             appl.application_id,
             appl.credit_id
      FROM   igs_fi_applications appl,
             igs_fi_credits_all crd,
             igs_fi_cr_types_all crt
      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 = crt.credit_type_id
      AND    crt.credit_class = 'WAIVER'
      AND    crd.fee_cal_type = cp_v_fee_cal_type
      AND    crd.fee_ci_sequence_number = cp_n_fee_ci_seq
      AND    crd.waiver_name = cp_v_waiver_name
      ORDER  BY appl.application_id;

Line: 333

      SELECT igs_fi_gen_007.get_sum_appl_amnt(application_id) amt_appl
      FROM   igs_fi_applications appl,
             igs_fi_inv_int_all inv
      WHERE  appl.invoice_id = inv.invoice_id
      AND    appl.credit_id  = cp_n_credit_id
      AND    inv.fee_cal_type = cp_v_fee_cal_type
      AND    inv.fee_ci_sequence_number = cp_n_fee_ci_seq
      AND    inv.transaction_type = 'WAIVER_ADJ'
      AND    appl.application_type = 'APP'
      AND    EXISTS (SELECT 'x'
                     FROM   igs_fi_credits_all crd1,
                igs_fi_applications appl1
         WHERE  appl1.credit_id = crd1.credit_id
         AND    crd1.credit_id  = cp_n_credit_id
         AND    appl1.invoice_id = cp_n_invoice_id
         AND    appl1.application_type = 'UNAPP'
         AND    appl1.amount_applied = - appl.amount_applied);

Line: 592

      SELECT fwp.*
      FROM   igs_fi_waiver_pgms fwp
      WHERE  fwp.target_fee_type  = cp_v_fee_type
      AND    fwp.fee_cal_type     = cp_v_fee_cal_type
      AND    fwp.fee_ci_sequence_number = cp_n_fee_ci_seq
      AND    ((fwp.waiver_name = cp_v_waiver_name) OR (cp_v_waiver_name IS NULL))
      ORDER BY fwp.creation_date;

Line: 604

      SELECT assignment_status_code
      FROM   igs_fi_wav_std_pgms
      WHERE  person_id = cp_n_person_id
      AND    fee_cal_type = cp_v_fee_cal_type
      AND    fee_ci_sequence_number = cp_n_fee_ci_seq
      AND    waiver_name = cp_v_waiver_name;

Line: 612

      SELECT NVL(waiver_notify_finaid_flag,'N') waiver_notify_finaid_flag
      FROM   igs_fi_control;

Line: 1023

      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.waiver_mode_code,
             fwp.adjustment_fee_type
      FROM   igs_fi_waiver_pgms fwp
      WHERE  fwp.target_fee_type = cp_v_fee_type
      AND    fwp.fee_cal_type     = cp_v_fee_cal_type
      AND    fwp.fee_ci_sequence_number = cp_n_fee_ci_seq
      AND    fwp.waiver_method_code = 'MANUAL';

Line: 1042

      SELECT credit_id,
             amount,
             unapplied_amount
      FROM   igs_fi_credits_all
      WHERE  party_id = cp_n_person_id
      AND    fee_cal_type = cp_v_fee_cal_type
      AND    fee_ci_sequence_number = cp_n_fee_ci_seq
      AND    waiver_name = cp_v_waiver_name
      AND    unapplied_amount > 0;

Line: 1053

      SELECT invoice_id
      FROM   igs_fi_applications
      WHERE  credit_id = cp_n_credit_id
      AND    application_type = 'UNAPP'
      ORDER BY application_id;

Line: 1214

     SELECT 'X'
     FROM igs_pe_persid_group_v
     WHERE group_id = cp_n_person_grp_id;

Line: 1222

     SELECT fwp.fee_cal_type,
            fwp.fee_ci_sequence_number,
            fwp.waiver_name,
            fwp.waiver_method_code,
            fwp.target_fee_type
     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_ci_seq_nbr
     AND    fwp.waiver_name = cp_v_waiver_name;

Line: 1236

     SELECT 'X'
     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_ci_seq_nbr
     AND   fwp.target_fee_type = cp_v_target_fee_type;

Line: 1467

      SELECT alternate_code
      FROM igs_ca_inst_all
      WHERE cal_type = cp_v_cal_type
      AND   sequence_number = cp_n_sequence_number;

Line: 1476

      SELECT group_cd
      FROM  igs_pe_persid_group_v
      WHERE group_id = c_group_id;

Line: 1584

      SELECT group_cd
      FROM  igs_pe_persid_group_v
      WHERE group_id = c_group_id;

Line: 1592

      SELECT alternate_code
      FROM igs_ca_inst_all
      WHERE cal_type = cp_v_cal_type
      AND   sequence_number = cp_n_sequence_number;

Line: 1601

    SELECT currency_cd
    FROM IGS_FI_CONTROL;

Line: 1611

    SELECT FWSP.WAIVER_NAME,
           FWSP.PERSON_ID,
           FWP.TARGET_FEE_TYPE
    FROM   IGS_FI_WAV_STD_PGMS FWSP,
           IGS_FI_WAIVER_PGMS FWP
    WHERE  FWSP.FEE_CAL_TYPE = cp_v_fee_cal_type
    AND    FWSP.FEE_CI_SEQUENCE_NUMBER = cp_n_fee_ci_seq_nbr
    AND    (cp_v_waiver_name IS NULL OR FWSP.WAIVER_NAME = cp_v_waiver_name)
    AND    (FWSP.PERSON_ID = cp_n_person_id OR cp_n_person_id IS NULL)
    AND    FWSP.FEE_CAL_TYPE = FWP.FEE_CAL_TYPE
    AND    FWSP.FEE_CI_SEQUENCE_NUMBER = FWP.FEE_CI_SEQUENCE_NUMBER
    AND    FWSP.WAIVER_NAME = FWP.WAIVER_NAME
    AND    (cp_v_fee_type IS NULL OR FWP.TARGET_FEE_TYPE = cp_v_fee_type);

Line: 1629

    SELECT FT.S_FEE_TYPE
    FROM   IGS_FI_FEE_TYPE_ALL FT
    WHERE  FT.FEE_TYPE = cp_v_target_fee_type;