[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fmast.*
FROM igf_aw_fund_mast fmast ,
igf_aw_fund_cat fcat
WHERE fmast.fund_code = fcat.fund_code
AND fmast.fund_id = cp_fund_id
AND fcat.sys_fund_type = g_c_fund_type
AND fmast.discontinue_fund = g_c_no;
SELECT sc_cal_type , sc_sequence_number,
sc_alternate_code , sc_start_dt,
sc_end_dt
FROM igf_aw_cal_rel_v
WHERE cr_cal_type = cp_cal_type
AND cr_sequence_number = cp_seq_num
AND active = 'Y';
SELECT meaning
FROM igs_lookup_values
WHERE lookup_type= 'YES_NO'
AND lookup_code= cp_run_flag
AND NVL(enabled_flag,'N') = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE))
AND TRUNC(NVL(end_date_active,SYSDATE));
SELECT '1'
FROM igs_ca_inst
WHERE cal_type = cp_cal_type
AND sequence_number = cp_sequence_number;
SELECT *
FROM igf_aw_fund_tp_v ftp
WHERE ftp.fund_id = cp_fund_id
ORDER BY tp_cal_type,tp_sequence_number;
SELECT *
FROM igf_sp_fc_v
WHERE fund_id = cp_fund_id
ORDER BY fee_cls_id;
SELECT *
FROM igf_sp_prg
WHERE fee_cls_id = cp_fee_cls_id
ORDER BY fee_cls_prg_id;
SELECT *
FROM igf_sp_unit
WHERE fee_cls_prg_id = cp_fee_cls_prg_id
ORDER BY fee_cls_unit_id;
igf_aw_fund_mast_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_fund_id => l_fund_id,
x_fund_code => l_c_igf_aw_fund_mast.fund_code,
x_ci_cal_type => p_sc_cal_type,
x_ci_sequence_number => p_sc_seq_num,
x_description => l_c_igf_aw_fund_mast.description,
x_discontinue_fund => l_c_igf_aw_fund_mast.discontinue_fund,
x_entitlement => l_c_igf_aw_fund_mast.entitlement,
x_auto_pkg => l_c_igf_aw_fund_mast.auto_pkg,
x_self_help => l_c_igf_aw_fund_mast.self_help,
x_allow_man_pkg => l_c_igf_aw_fund_mast.allow_man_pkg,
x_update_need => l_c_igf_aw_fund_mast.update_need,
x_disburse_fund => l_c_igf_aw_fund_mast.disburse_fund,
x_available_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.available_amt),
x_offered_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.offered_amt),
x_pending_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.pending_amt),
x_accepted_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.accepted_amt),
x_declined_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.declined_amt),
x_cancelled_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.cancelled_amt),
x_remaining_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.remaining_amt),
x_enrollment_status => l_c_igf_aw_fund_mast.enrollment_status,
x_prn_award_letter => l_c_igf_aw_fund_mast.prn_award_letter,
x_over_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.over_award_amt),
x_over_award_perct => l_c_igf_aw_fund_mast.over_award_perct,
x_min_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_award_amt),
x_max_award_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_award_amt),
x_max_yearly_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_yearly_amt),
x_max_life_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.max_life_amt),
x_max_life_term => l_c_igf_aw_fund_mast.max_life_term,
x_fm_fc_methd => l_c_igf_aw_fund_mast.fm_fc_methd,
x_roundoff_fact => l_c_igf_aw_fund_mast.roundoff_fact,
x_replace_fc => l_c_igf_aw_fund_mast.replace_fc,
x_allow_overaward => l_c_igf_aw_fund_mast.allow_overaward,
x_pckg_awd_stat => l_c_igf_aw_fund_mast.pckg_awd_stat,
x_org_record_req => l_c_igf_aw_fund_mast.org_record_req,
x_disb_record_req => l_c_igf_aw_fund_mast.disb_record_req,
x_prom_note_req => l_c_igf_aw_fund_mast.prom_note_req,
x_min_num_disb => l_c_igf_aw_fund_mast.min_num_disb,
x_max_num_disb => l_c_igf_aw_fund_mast.max_num_disb,
x_fee_type => l_c_igf_aw_fund_mast.fee_type,
x_total_offered => l_c_igf_aw_fund_mast.total_offered,
x_total_accepted => l_c_igf_aw_fund_mast.total_accepted,
x_total_declined => l_c_igf_aw_fund_mast.total_declined,
x_total_revoked => l_c_igf_aw_fund_mast.total_revoked,
x_total_cancelled => l_c_igf_aw_fund_mast.total_cancelled,
x_total_disbursed => l_c_igf_aw_fund_mast.total_disbursed,
x_total_committed => l_c_igf_aw_fund_mast.total_committed,
x_committed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.committed_amt),
x_disbursed_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.disbursed_amt),
x_awd_notice_txt => l_c_igf_aw_fund_mast.awd_notice_txt,
x_attribute_category => l_c_igf_aw_fund_mast.attribute_category,
x_attribute1 => l_c_igf_aw_fund_mast.attribute1,
x_attribute2 => l_c_igf_aw_fund_mast.attribute2,
x_attribute3 => l_c_igf_aw_fund_mast.attribute3,
x_attribute4 => l_c_igf_aw_fund_mast.attribute4,
x_attribute5 => l_c_igf_aw_fund_mast.attribute5,
x_attribute6 => l_c_igf_aw_fund_mast.attribute6,
x_attribute7 => l_c_igf_aw_fund_mast.attribute7,
x_attribute8 => l_c_igf_aw_fund_mast.attribute8,
x_attribute9 => l_c_igf_aw_fund_mast.attribute9,
x_attribute10 => l_c_igf_aw_fund_mast.attribute10,
x_attribute11 => l_c_igf_aw_fund_mast.attribute11,
x_attribute12 => l_c_igf_aw_fund_mast.attribute12,
x_attribute13 => l_c_igf_aw_fund_mast.attribute13,
x_attribute14 => l_c_igf_aw_fund_mast.attribute14,
x_attribute15 => l_c_igf_aw_fund_mast.attribute15,
x_attribute16 => l_c_igf_aw_fund_mast.attribute16,
x_attribute17 => l_c_igf_aw_fund_mast.attribute17,
x_attribute18 => l_c_igf_aw_fund_mast.attribute18,
x_attribute19 => l_c_igf_aw_fund_mast.attribute19,
x_attribute20 => l_c_igf_aw_fund_mast.attribute20,
x_disb_verf_da => l_c_igf_aw_fund_mast.disb_verf_da,
x_fund_exp_da => l_c_igf_aw_fund_mast.fund_exp_da,
x_nslds_disb_da => l_c_igf_aw_fund_mast.nslds_disb_da,
x_disb_exp_da => l_c_igf_aw_fund_mast.disb_exp_da,
x_fund_recv_reqd => l_c_igf_aw_fund_mast.fund_recv_reqd,
x_show_on_bill => l_c_igf_aw_fund_mast.show_on_bill,
x_bill_desc => l_c_igf_aw_fund_mast.bill_desc,
x_credit_type_id => l_c_igf_aw_fund_mast.credit_type_id,
x_spnsr_ref_num => l_c_igf_aw_fund_mast.spnsr_ref_num,
x_threshold_perct => l_c_igf_aw_fund_mast.threshold_perct,
x_threshold_value => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.threshold_value),
x_party_id => l_c_igf_aw_fund_mast.party_id,
x_spnsr_fee_type => l_c_igf_aw_fund_mast.spnsr_fee_type,
x_min_credit_points => l_c_igf_aw_fund_mast.min_credit_points,
x_group_id => l_c_igf_aw_fund_mast.group_id,
x_spnsr_attribute_category => l_c_igf_aw_fund_mast.spnsr_attribute_category,
x_spnsr_attribute1 => l_c_igf_aw_fund_mast.spnsr_attribute1,
x_spnsr_attribute2 => l_c_igf_aw_fund_mast.spnsr_attribute2,
x_spnsr_attribute3 => l_c_igf_aw_fund_mast.spnsr_attribute3,
x_spnsr_attribute4 => l_c_igf_aw_fund_mast.spnsr_attribute4,
x_spnsr_attribute5 => l_c_igf_aw_fund_mast.spnsr_attribute5,
x_spnsr_attribute6 => l_c_igf_aw_fund_mast.spnsr_attribute6,
x_spnsr_attribute7 => l_c_igf_aw_fund_mast.spnsr_attribute7,
x_spnsr_attribute8 => l_c_igf_aw_fund_mast.spnsr_attribute8,
x_spnsr_attribute9 => l_c_igf_aw_fund_mast.spnsr_attribute9,
x_spnsr_attribute10 => l_c_igf_aw_fund_mast.spnsr_attribute10,
x_spnsr_attribute11 => l_c_igf_aw_fund_mast.spnsr_attribute11,
x_spnsr_attribute12 => l_c_igf_aw_fund_mast.spnsr_attribute12,
x_spnsr_attribute13 => l_c_igf_aw_fund_mast.spnsr_attribute13,
x_spnsr_attribute14 => l_c_igf_aw_fund_mast.spnsr_attribute14,
x_spnsr_attribute15 => l_c_igf_aw_fund_mast.spnsr_attribute15,
x_spnsr_attribute16 => l_c_igf_aw_fund_mast.spnsr_attribute16,
x_spnsr_attribute17 => l_c_igf_aw_fund_mast.spnsr_attribute17,
x_spnsr_attribute18 => l_c_igf_aw_fund_mast.spnsr_attribute18,
x_spnsr_attribute19 => l_c_igf_aw_fund_mast.spnsr_attribute19,
x_spnsr_attribute20 => l_c_igf_aw_fund_mast.spnsr_attribute20,
x_ver_app_stat_override => l_c_igf_aw_fund_mast.ver_app_stat_override ,
x_gift_aid => l_c_igf_aw_fund_mast.gift_aid,
x_send_without_doc => l_c_igf_aw_fund_mast.send_without_doc, -- Bug # 2758812. Added send_without_doc column.
x_re_pkg_verif_flag => l_c_igf_aw_fund_mast.re_pkg_verif_flag,
x_donot_repkg_if_code => l_c_igf_aw_fund_mast.donot_repkg_if_code,
x_lock_award_flag => l_c_igf_aw_fund_mast.lock_award_flag,
x_disb_rounding_code => l_c_igf_aw_fund_mast.disb_rounding_code,
x_view_only_flag => l_c_igf_aw_fund_mast.view_only_flag,
x_accept_less_amt_flag => l_c_igf_aw_fund_mast.accept_less_amt_flag,
x_allow_inc_post_accept_flag => l_c_igf_aw_fund_mast.allow_inc_post_accept_flag,
x_min_increase_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_increase_amt),
x_allow_dec_post_accept_flag => l_c_igf_aw_fund_mast.allow_dec_post_accept_flag,
x_min_decrease_amt => igs_fi_gen_gl.get_formatted_amount(l_c_igf_aw_fund_mast.min_decrease_amt),
x_allow_decln_post_accept_flag => l_c_igf_aw_fund_mast.allow_decln_post_accept_flag,
x_status_after_decline => l_c_igf_aw_fund_mast.status_after_decline,
x_fund_information_txt => l_c_igf_aw_fund_mast.fund_information_txt
);
igf_aw_fund_tp_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_fund_id => l_fund_id,
x_tp_cal_type => l_c_igf_aw_cal_rel.sc_cal_type,
x_tp_sequence_number => l_c_igf_aw_cal_rel.sc_sequence_number,
x_tp_perct => l_c_igf_aw_fund_tp.tp_perct
);
igf_sp_fc_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_fee_cls_id => l_fee_cls_id,
x_fund_id => l_fund_id,
x_fee_class => l_c_igf_sp_fc.fee_class,
x_fee_percent => l_c_igf_sp_fc.fee_percent,
x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_fc.max_amount)
);
igf_sp_prg_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_fee_cls_prg_id => l_fee_cls_prg_id,
x_fee_cls_id => l_fee_cls_id,
x_course_cd => l_c_igf_sp_prg.course_cd,
x_version_number => l_c_igf_sp_prg.version_number,
x_fee_percent => l_c_igf_sp_prg.fee_percent,
x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_prg.max_amount)
);
igf_sp_unit_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_fee_cls_unit_id => l_fee_cls_unit_id,
x_fee_cls_prg_id => l_fee_cls_prg_id,
x_unit_cd => l_c_igf_sp_unit.unit_cd,
x_version_number => l_c_igf_sp_unit.version_number,
x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_unit.max_amount)
);
SELECT fmast.*
FROM igf_aw_fund_mast fmast ,
igf_aw_fund_cat fcat
WHERE fmast.fund_code = fcat.fund_code
AND fmast.fund_code = cp_fund_code
AND fmast.ci_cal_type = cp_cal_type
AND fmast.ci_sequence_number = cp_sequence_number
AND fcat.sys_fund_type = g_c_fund_type
AND fmast.discontinue_fund = g_c_no;
SELECT *
FROM igf_aw_fund_tp_v ftp
WHERE ftp.fund_id = cp_fund_id;
SELECT *
FROM igf_sp_stdnt_rel_v
WHERE fund_id = cp_fund_id ;
SELECT base_id
FROM igf_ap_fa_base_rec
WHERE person_id = cp_person_id
AND ci_cal_type = cp_cal_type
AND ci_sequence_number = cp_seq_num;
SELECT *
FROM igf_sp_std_fc_v
WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id;
SELECT *
FROM igf_sp_std_prg
WHERE fee_cls_id = cp_fee_cls_id;
SELECT *
FROM igf_sp_std_unit
WHERE fee_cls_prg_id = cp_fee_cls_prg_id;
igf_sp_stdnt_rel_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_spnsr_stdnt_id => l_spnsr_stdnt_id,
x_fund_id => l_c_fund_mast.fund_id,
x_base_id => l_base_id,
x_person_id => l_c_igf_sp_stdnt_rel.person_id,
x_ld_cal_type => l_c_igf_aw_cal_rel.sc_cal_type,
x_ld_sequence_number => l_c_igf_aw_cal_rel.sc_sequence_number,
x_tot_spnsr_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_stdnt_rel.tot_spnsr_amount),
x_min_credit_points => l_c_igf_sp_stdnt_rel.min_credit_points,
x_min_attendance_type => l_c_igf_sp_stdnt_rel.min_attendance_type
);
igf_sp_std_fc_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_fee_cls_id => l_fee_cls_id,
x_spnsr_stdnt_id => l_spnsr_stdnt_id,
x_fee_class => l_c_igf_sp_std_fc.fee_class,
x_fee_percent => l_c_igf_sp_std_fc.fee_percent,
x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_fc.max_amount)
);
igf_sp_std_prg_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_fee_cls_prg_id => l_fee_cls_prg_id,
x_fee_cls_id => l_fee_cls_id,
x_course_cd => l_c_igf_sp_std_prg.course_cd,
x_version_number => l_c_igf_sp_std_prg.version_number,
x_fee_percent => l_c_igf_sp_std_prg.fee_percent,
x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_prg.max_amount)
);
igf_sp_std_unit_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_fee_cls_unit_id => l_fee_cls_unit_id,
x_fee_cls_prg_id => l_fee_cls_prg_id,
x_unit_cd => l_c_igf_sp_std_unit.unit_cd,
x_version_number => l_c_igf_sp_std_unit.version_number,
x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_unit.max_amount)
);