APPS.IGS_FI_GEN_REFUNDS SQL Statements

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

Line: 35

  SELECT NVL(fund_authorization,'N') fund_authorization
  FROM   igs_pe_hz_parties
  WHERE  party_id = cp_person_id;

Line: 76

  SELECT ft.fee_type
  FROM   igs_fi_f_typ_ca_inst ftci,
         igs_fi_fee_type ft,
         igs_fi_fee_str_stat fsst
  WHERE  ft.fee_type = ftci.fee_type
  AND    ftci.fee_cal_type = p_fee_cal_type
  AND    ftci.fee_ci_sequence_number = p_fee_ci_sequence_number
  AND    ftci.fee_type_ci_status = fsst.fee_structure_status
  AND    fsst.s_fee_structure_status = g_active
  AND    ft.s_fee_type = g_refund
  AND    NVL(ft.closed_ind,'N') = 'N';

Line: 92

  SELECT ftci.fee_type,
         ci.cal_type,
         ci.sequence_number
  FROM   igs_fi_fee_type ft,
         igs_fi_f_typ_ca_inst ftci,
         igs_ca_inst ci,
         igs_fi_fee_str_stat fsst
  WHERE  ft.fee_type = ftci.fee_type
  AND    ft.s_fee_type = g_refund
  AND    ci.cal_type = ftci.fee_cal_type
  AND    ci.sequence_number = ftci.fee_ci_sequence_number
  AND    ftci.fee_type_ci_status = fsst.fee_structure_status
  AND    fsst.s_fee_structure_status = g_active
  AND    (TRUNC(SYSDATE) BETWEEN TRUNC(ci.start_dt) AND TRUNC(NVL(ci.end_dt,SYSDATE)))
  AND    NVL(ft.closed_ind,'N') = 'N'
  ORDER BY ci.start_dt, ci.sequence_number ASC;

Line: 157

  SELECT 'X'
  FROM   igs_pe_persenc_effct
  WHERE  person_id = cp_person_id
  AND    s_encmb_effect_type = g_stoprefund
  AND    TRUNC(NVL(expiry_dt,SYSDATE)) >= TRUNC(SYSDATE);

Line: 196

  SELECT refund_dt_alias
  FROM   igs_fi_control;

Line: 204

  SELECT alias_val
  FROM   igs_ca_da_inst_v
  WHERE  cal_type = cp_fee_cal_type
  AND    ci_sequence_number = cp_fee_ci_sequence_number
  AND    dt_alias = cp_date_alias
  ORDER BY alias_val DESC;

Line: 268

  SELECT award_id
  FROM   igf_db_awd_disb_dtl
  WHERE  sf_credit_id = cp_credit_id;

Line: 275

  SELECT NVL(borw_detrm_code,g_borrower) borw_detrm_code
  FROM   igf_sl_loans
  WHERE  award_id = cp_award_id;

Line: 342

  SELECT refund_dr_gl_ccid,
         refund_cr_gl_ccid,
         refund_dr_account_cd,
         refund_cr_account_cd,
         NVL(rec_installed,'N') rec_installed
  FROM   igs_fi_control;