[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT award_year_status_code
FROM igf_ap_batch_aw_map
WHERE ci_cal_type = cp_v_cal_type
AND ci_sequence_number = cp_n_ci_seq_number;
SELECT inst.rowid row_id, inst.*
FROM igs_fi_pp_instlmnts inst,
igs_fi_pp_std_attrs stt
WHERE stt.student_plan_id = inst.student_plan_id AND
stt.person_id = cp_n_person_id AND
stt.plan_status_code = cp_v_plan_status AND
inst.due_amt > 0
ORDER BY inst.due_date;
SELECT stt.rowid row_id,stt.*
FROM igs_fi_pp_std_attrs stt
WHERE stt.person_id = cp_n_person_id AND
stt.plan_status_code = cp_v_plan_status;
igs_fi_pp_instlmnts_pkg.update_row(
x_rowid => rec_cur_pp_insts.row_id,
x_installment_id => rec_cur_pp_insts.installment_id,
x_student_plan_id => rec_cur_pp_insts.student_plan_id,
x_installment_line_num => rec_cur_pp_insts.installment_line_num,
x_due_day => rec_cur_pp_insts.due_day,
x_due_month_code => rec_cur_pp_insts.due_month_code,
x_due_year => rec_cur_pp_insts.due_year,
x_due_date => rec_cur_pp_insts.due_date,
x_installment_amt => rec_cur_pp_insts.installment_amt,
x_due_amt => l_n_amt_due,
x_penalty_flag => rec_cur_pp_insts.penalty_flag,
x_mode => 'R'
);
igs_fi_pp_ins_appls_pkg.insert_row(
x_rowid => l_rowid,
x_installment_application_id => l_n_inst_appl_id,
x_application_type_code => 'APP',
x_installment_id => rec_cur_pp_insts.installment_id,
x_credit_id => p_n_credit_id,
x_credit_activity_id => p_n_cr_activity_id,
x_applied_amt => l_n_amt_apply,
x_transaction_date => TRUNC(SYSDATE),
x_link_application_id => NULL,
x_mode => 'R'
);
igs_fi_pp_std_attrs_pkg.update_row(
x_rowid => rec_cur_pmt_plan.row_id,
x_student_plan_id => rec_cur_pmt_plan.student_plan_id,
x_person_id => rec_cur_pmt_plan.person_id,
x_payment_plan_name => rec_cur_pmt_plan.payment_plan_name,
x_plan_start_date => rec_cur_pmt_plan.plan_start_date,
x_plan_end_date => TRUNC(SYSDATE),
x_plan_status_code => 'CLOSED',
x_processing_fee_amt => rec_cur_pmt_plan.processing_fee_amt,
x_processing_fee_type => rec_cur_pmt_plan.processing_fee_type,
x_fee_cal_type => rec_cur_pmt_plan.fee_cal_type,
x_fee_ci_sequence_number => rec_cur_pmt_plan.fee_ci_sequence_number,
x_notes => rec_cur_pmt_plan.notes,
x_invoice_id => rec_cur_pmt_plan.invoice_id,
x_attribute_category => rec_cur_pmt_plan.attribute_category,
x_attribute1 => rec_cur_pmt_plan.attribute1,
x_attribute2 => rec_cur_pmt_plan.attribute2,
x_attribute3 => rec_cur_pmt_plan.attribute3,
x_attribute4 => rec_cur_pmt_plan.attribute4,
x_attribute5 => rec_cur_pmt_plan.attribute5,
x_attribute6 => rec_cur_pmt_plan.attribute6,
x_attribute7 => rec_cur_pmt_plan.attribute7,
x_attribute8 => rec_cur_pmt_plan.attribute8,
x_attribute9 => rec_cur_pmt_plan.attribute9,
x_attribute10 => rec_cur_pmt_plan.attribute10,
x_attribute11 => rec_cur_pmt_plan.attribute11,
x_attribute12 => rec_cur_pmt_plan.attribute12,
x_attribute13 => rec_cur_pmt_plan.attribute13,
x_attribute14 => rec_cur_pmt_plan.attribute14,
x_attribute15 => rec_cur_pmt_plan.attribute15,
x_attribute16 => rec_cur_pmt_plan.attribute16,
x_attribute17 => rec_cur_pmt_plan.attribute17,
x_attribute18 => rec_cur_pmt_plan.attribute18,
x_attribute19 => rec_cur_pmt_plan.attribute19,
x_attribute20 => rec_cur_pmt_plan.attribute20,
x_mode => 'R'
);
SELECT credit_type_name
FROM igs_fi_cr_types
WHERE credit_type_id = p_credit_type_id;
SELECT 'x'
FROM igs_lookup_values
WHERE lookup_type = cp_lookup_type
AND lookup_code = cp_lookup_code
AND enabled_flag = cp_enabled_flag
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE, SYSDATE));
SELECT 'x'
FROM igf_lookups_view
WHERE lookup_type = cp_lookup_type
AND lookup_code = cp_lookup_code
AND enabled_flag= cp_enabled_flag;
SELECT credit_class
FROM igs_fi_cr_types_all
WHERE credit_type_id = cp_credit_type_id
AND TRUNC(SYSDATE) BETWEEN TRUNC(effective_start_date) AND TRUNC(NVL(effective_end_date,SYSDATE));
SELECT 'x'
FROM fnd_currencies_active_v
WHERE currency_code = cp_currency_cd
AND currency_code <> 'STAT';
SELECT 'x'
FROM igs_ca_inst ci,
igs_ca_type cat,
igs_ca_stat stat
WHERE ci.cal_type = cp_cal_type
AND ci.sequence_number = cp_ci_sequence_number
AND ci.cal_status = stat.cal_status
AND stat.s_cal_status = 'ACTIVE'
AND ci.cal_type = cat.cal_type
AND cat.s_cal_cat = cp_s_cal_cat;
SELECT c.payment_credit_type_id
FROM igs_fi_cr_types c
WHERE c.credit_type_id = cp_cr_typ_id
AND TRUNC(SYSDATE) BETWEEN TRUNC(c.effective_start_date) AND TRUNC(NVL(c.effective_end_date,SYSDATE))
AND EXISTS (SELECT 'x'
FROM igs_fi_cr_types p
WHERE p.credit_type_id = c.payment_credit_type_id
AND TRUNC(SYSDATE) BETWEEN TRUNC(p.effective_start_date) AND TRUNC(NVL(p.effective_end_date,SYSDATE)));
SELECT 'x'
FROM hz_parties
WHERE party_id = cp_party_id
AND party_type = cp_party_type;
SELECT 'x'
FROM igs_ad_appl appl
WHERE appl.person_id = cp_party_id
AND appl.application_id = cp_appl_id
AND EXISTS ( SELECT 'X'
FROM igs_ad_ps_appl_inst apl_in,
igs_ad_ofrdfrmt_stat df,
igs_ad_ofr_resp_stat off
WHERE apl_in.person_id = appl.person_id
AND apl_in.admission_appl_number = appl.admission_appl_number
AND apl_in.adm_offer_resp_status = off.adm_offer_resp_status
AND apl_in.adm_offer_dfrmnt_status = df.adm_offer_dfrmnt_status
AND (off.s_adm_offer_resp_status ='ACCEPTED' OR
(off.s_adm_offer_resp_status ='DEFERRAL' AND df.s_adm_offer_dfrmnt_status = 'CONFIRM')
));
SELECT 'x'
FROM igs_fi_inv_int
WHERE invoice_id=cp_invoice_id;
SELECT name, payeeid
FROM iby_payee
WHERE payeeid = cp_payeeid
AND NVL(activestatus,'N')='Y';