[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rfmd.*,
rfms.inst_cross_ref_cd,
rfms.base_id,
rfms.award_id,
rfms.transaction_num,
rfms.ci_cal_type,
rfms.ci_sequence_number,
rfms.rep_pell_id,
rfms.attending_campus_id,
rfms.pell_amount
FROM igf_gr_rfms rfms ,
igf_gr_rfms_disb rfmd,
igf_gr_pell_setup setup
WHERE rfms.base_id = NVL(l_base_id,rfms.base_id)
AND rfms.ci_cal_type = l_ci_cal_type
AND rfms.ci_sequence_number = l_ci_sequence_number
AND rfms.rep_pell_id = cp_reporting_pell
AND rfms.attending_campus_id = NVL(cp_attending_pell, rfms.attending_campus_id)
AND rfmd.disb_ack_act_status = 'R'
AND rfmd.origination_id = rfms.origination_id
AND rfmd.disb_ref_num IN (SELECT disb.disb_num
FROM igf_aw_awd_disb_all disb
WHERE disb.trans_type IN ('A')
AND disb.award_id = rfms.award_id
AND g_trans_type IN ('A','P')
UNION ALL
SELECT disb.disb_num
FROM igf_aw_awd_disb_all disb
WHERE disb.trans_type IN ('P')
AND disb.award_id = rfms.award_id
AND disb.disb_date <= DECODE(setup.funding_method,'J',TRUNC(SYSDATE) + 7,'A',TRUNC(SYSDATE) + 30)
AND g_trans_type = 'P'
)
AND setup.rep_pell_id = rfms.rep_pell_id
AND setup.ci_cal_type = rfms.ci_cal_type
AND setup.ci_sequence_number = rfms.ci_sequence_number
AND rfms.orig_action_code IN ('A','D','C')
ORDER BY rfms.origination_id
FOR UPDATE OF disb_ack_act_status NOWAIT;
igf_gr_rfms_disb_pkg.update_row (
x_rowid => p_rec_disb_orig.row_id,
x_rfmd_id => p_rec_disb_orig.rfmd_id ,
x_origination_id => p_rec_disb_orig.origination_id,
x_disb_ref_num => p_rec_disb_orig.disb_ref_num,
x_disb_dt => p_rec_disb_orig.disb_dt,
x_disb_amt => p_rec_disb_orig.disb_amt,
x_db_cr_flag => p_rec_disb_orig.db_cr_flag,
x_disb_ack_act_status => 'S', -- record processed
x_disb_status_dt => p_rec_disb_orig.disb_status_dt,
x_accpt_disb_dt => p_rec_disb_orig.accpt_disb_dt ,
x_disb_accpt_amt => p_rec_disb_orig.disb_accpt_amt,
x_accpt_db_cr_flag => p_rec_disb_orig.accpt_db_cr_flag,
x_disb_ytd_amt => p_rec_disb_orig.disb_ytd_amt,
x_pymt_prd_start_dt => p_rec_disb_orig.pymt_prd_start_dt,
x_accpt_pymt_prd_start_dt => p_rec_disb_orig.accpt_pymt_prd_start_dt,
x_edit_code => p_rec_disb_orig.edit_code ,
x_rfmb_id => p_rfmb_id,
x_mode => 'R',
x_ed_use_flags => p_rec_disb_orig.ed_use_flags);
fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');
SELECT
igf_gr_rfms_error.message
FROM igf_gr_rfms_error
WHERE
igf_gr_rfms_error.edit_code = l_err_cd;
SELECT isir.transaction_num
FROM igf_ap_isir_matched isir
WHERE isir.base_id = l_base_id
AND isir.payment_isir = 'Y' ;
SELECT 'Y'
FROM igf_gr_report_pell rep,
igf_gr_attend_pell att
WHERE rep.rcampus_id = att.rcampus_id
AND rep.ci_cal_type = cp_ci_cal_type
AND rep.ci_sequence_number = cp_ci_sequence_number
AND rep.reporting_pell_cd = cp_reporting_pell
AND att.attending_pell_cd = cp_attending_pell;
SELECT SUM(disb_amt) disb_amt_tot
FROM igf_gr_rfms_disb
WHERE origination_id = cp_origination_id;
SELECT
rfmb_id
FROM
igf_gr_rfms_batch
WHERE batch_id = p_batch_id;
SELECT
*
FROM
igf_gr_rfms
WHERE
origination_id = l_origination_id;
SELECT record_data
FROM
igf_gr_load_file_t
WHERE
gldr_id BETWEEN 2 AND (l_last_gldr_id - 1)
AND file_type = 'GR_RFMS_DISB_ORIG';
SELECT *
FROM igf_gr_rfms_disb
WHERE
origination_id = l_origination_id AND
disb_ref_num = l_disb_ref_num
FOR UPDATE OF edit_code NOWAIT;
igf_gr_rfms_disb_pkg.update_row (
x_rowid => rec_disb_orig.row_id,
x_rfmd_id => l_rfms.rfmd_id ,
x_origination_id => l_rfms.origination_id,
x_disb_ref_num => l_rfms.disb_ref_num,
x_disb_dt => l_rfms.disb_dt,
x_disb_amt => l_rfms.disb_amt,
x_db_cr_flag => l_rfms.db_cr_flag,
x_disb_ack_act_status => l_rfms.disb_ack_act_status,
x_disb_status_dt => l_rfms.disb_status_dt,
x_accpt_disb_dt => l_rfms.accpt_disb_dt ,
x_disb_accpt_amt => l_rfms.disb_accpt_amt,
x_accpt_db_cr_flag => l_rfms.accpt_db_cr_flag,
x_disb_ytd_amt => l_rfms.disb_ytd_amt,
x_pymt_prd_start_dt => l_rfms.pymt_prd_start_dt,
x_accpt_pymt_prd_start_dt => l_rfms.accpt_pymt_prd_start_dt,
x_edit_code => l_rfms.edit_code,
x_rfmb_id => l_rfms.rfmb_id,
x_mode => 'R',
x_ed_use_flags => l_rfms.ed_use_flags);
igf_gr_gen.insert_sys_holds(rec_award.award_id,rec_disb_orig.disb_ref_num,'PELL');
SELECT group_cd group_name
FROM igs_pe_persid_group_all
WHERE group_id = cp_persid_grp;
OPEN c_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_ci_cal_type,l_ci_sequence_number,p_pers_id_grp;
OPEN c_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_ci_cal_type,l_ci_sequence_number;