[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT orig_fee_perct_stafford,
orig_fee_perct_plus,
int_rebate
FROM igf_sl_dl_setup
WHERE ci_cal_type = p_ci_cal_type
AND ci_sequence_number = p_ci_seq_num;
SELECT fed_fund_code
FROM igf_aw_award awd,
igf_aw_fund_mast fundmast,
igf_aw_fund_cat fundcat
WHERE awd.award_id = cp_award_id
AND awd.fund_id = fundmast.fund_id
AND fundmast.fund_code = fundcat.fund_code;
SELECT hold_rel_ind FROM igf_sl_cl_setup
WHERE ci_cal_type = p_ci_cal_type
AND ci_sequence_number = p_ci_seq_num
AND NVL(relationship_cd,'*') = cp_rel_code
AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);
SELECT auto_late_disb_ind
FROM igf_sl_cl_setup
WHERE ci_cal_type = p_ci_cal_type
AND ci_sequence_number = p_ci_seq_num
AND NVL(relationship_cd,'*') = cp_rel_code
AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);
SELECT est_orig_fee_perct,
est_alt_orig_fee_perct
FROM igf_sl_cl_setup
WHERE ci_cal_type = p_ci_cal_type
AND ci_sequence_number = p_ci_seq_num
AND NVL(relationship_cd,'*') = cp_rel_code
AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);
SELECT est_guarnt_fee_perct,
est_alt_guarnt_fee_perct
FROM igf_sl_cl_setup
WHERE ci_cal_type = p_ci_cal_type
AND ci_sequence_number = p_ci_seq_num
AND NVL(relationship_cd,'*') = cp_rel_code
AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);
SELECT disb.award_id
,disb.disb_date
,disb.disb_num
FROM igf_aw_awd_disb_all disb
,igf_sl_loans_all loans
WHERE loans.award_id=disb.award_id
AND loans.award_id = cp_n_award_id
AND ( disb.disb_date < NVL(cp_loan_per_begin_date, loans.loan_per_begin_date)
OR disb.disb_date > NVL(cp_loan_per_end_date, loans.loan_per_end_date));
SELECT alt_rel_code
FROM igf_aw_fund_cat_all
WHERE fund_code = cp_fund_code;
SELECT loan_id
,loan_status
,loan_chg_status
FROM igf_sl_loans
WHERE award_id = p_award_id;
Changed calll to igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code
(reverse chronological order - newest change first)
***************************************************************/
l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
SELECT *
FROM igf_aw_awd_disb adisb
WHERE adisb.award_id = p_award_id;
select
fcat.alt_rel_code alt_rel_code
from
igf_aw_award_all awd,
igf_aw_fund_mast_all fmast,
igf_aw_fund_cat_all fcat
where
awd.fund_id = fmast.fund_id
and fmast.fund_code = fcat.fund_code
and awd.award_id = cp_award_id ;
igf_aw_awd_disb_pkg.update_row( x_rowid => get_adisb_rec.row_id ,
x_award_id => get_adisb_rec.award_id ,
x_disb_num => get_adisb_rec.disb_num ,
x_tp_cal_type => get_adisb_rec.tp_cal_type ,
x_tp_sequence_number => get_adisb_rec.tp_sequence_number ,
x_disb_gross_amt => get_adisb_rec.disb_gross_amt ,
x_fee_1 => (l_fee1 * NVL(get_adisb_rec.disb_accepted_amt,0)) / 100,
x_fee_2 => (l_fee2 * NVL(get_adisb_rec.disb_accepted_amt,0)) / 100,
x_disb_net_amt => l_net_amt,
x_disb_date => get_adisb_rec.disb_date ,
x_trans_type => get_adisb_rec.trans_type ,
x_elig_status => get_adisb_rec.elig_status ,
x_elig_status_date => get_adisb_rec.elig_status_date ,
x_affirm_flag => get_adisb_rec.affirm_flag ,
x_hold_rel_ind => get_adisb_rec.hold_rel_ind ,
x_manual_hold_ind => get_adisb_rec.manual_hold_ind ,
x_disb_status => get_adisb_rec.disb_status ,
x_disb_status_date => get_adisb_rec.disb_status_date ,
x_late_disb_ind => get_adisb_rec.late_disb_ind ,
x_fund_dist_mthd => get_adisb_rec.fund_dist_mthd ,
x_prev_reported_ind => get_adisb_rec.prev_reported_ind ,
x_fund_release_date => get_adisb_rec.fund_release_date ,
x_fund_status => get_adisb_rec.fund_status ,
x_fund_status_date => get_adisb_rec.fund_status_date ,
x_fee_paid_1 => get_adisb_rec.fee_paid_1 ,
x_fee_paid_2 => get_adisb_rec.fee_paid_2 ,
x_cheque_number => get_adisb_rec.cheque_number ,
x_ld_cal_type => get_adisb_rec.ld_cal_type ,
x_ld_sequence_number => get_adisb_rec.ld_sequence_number ,
x_disb_accepted_amt => get_adisb_rec.disb_accepted_amt ,
x_disb_paid_amt => get_adisb_rec.disb_paid_amt ,
x_rvsn_id => get_adisb_rec.rvsn_id ,
x_int_rebate_amt => get_adisb_rec.int_rebate_amt ,
x_force_disb => get_adisb_rec.force_disb ,
x_min_credit_pts => get_adisb_rec.min_credit_pts ,
x_disb_exp_dt => get_adisb_rec.disb_exp_dt ,
x_verf_enfr_dt => get_adisb_rec.verf_enfr_dt ,
x_fee_class => get_adisb_rec.fee_class ,
x_show_on_bill => get_adisb_rec.show_on_bill ,
x_mode => 'R',
x_attendance_type_code => get_adisb_rec.attendance_type_code,
x_base_attendance_type_code => get_adisb_rec.base_attendance_type_code,
x_payment_prd_st_date => get_adisb_rec.payment_prd_st_date,
x_change_type_code => get_adisb_rec.change_type_code,
x_fund_return_mthd_code => get_adisb_rec.fund_return_mthd_code,
x_direct_to_borr_flag => get_adisb_rec.direct_to_borr_flag
);
SELECT person_id
FROM igf_ap_fa_base_rec_all
WHERE base_id = cp_base_id;
SELECT relationship_cd
FROM igf_sl_cl_pref_lenders
WHERE person_id = cp_person_id
AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
SELECT relationship_cd
FROM igf_sl_cl_setup
WHERE ci_cal_type = cp_cal_type
AND ci_sequence_number = cp_sequence_number
AND NVL(default_flag,'N') = cp_default_flag
AND party_id IS NULL;
SELECT relationship_cd
FROM igf_sl_cl_setup
WHERE ci_cal_type = cp_cal_type
AND ci_sequence_number = cp_sequence_number
AND cp_rel_code = NVL(relationship_cd,'*')
AND cp_party_id = NVL(party_id,-1000);
SELECT relationship_cd
FROM igf_sl_cl_setup
WHERE ci_cal_type = cp_cal_type
AND ci_sequence_number = cp_sequence_number
AND NVL(default_flag,'N') = cp_default_flag
AND NVL(party_id,-1000) = cp_party_id;
SELECT relationship_cd
FROM igf_sl_cl_setup
WHERE ci_cal_type = cp_cal_type
AND ci_sequence_number = cp_sequence_number
AND cp_rel_code = relationship_cd
AND party_id IS NULL;
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.pick_setup.debug','The value select_org returned : '||g_party_id);
SELECT loans.loan_number
FROM igf_sl_lor_all lor
,igf_sl_loans_all loans
,igf_aw_award_all awd
,igf_aw_fund_mast_all fmast
,igf_sl_cl_setup_all clset
WHERE loans.loan_id = lor.loan_id
AND loans.award_id = cp_n_award_id
AND lor.prc_type_code IN ('GO','GP')
AND ( lor.guarnt_status_code = '40' OR lor.cl_rec_status IN ('B','G'))
AND loans.loan_status = 'A'
AND NVL (loans.loan_chg_status,'*') <> 'S'
AND awd.award_id = loans.award_id
AND fmast.fund_id = awd.fund_id
AND fmast.ci_cal_type = clset.ci_cal_type
AND fmast.ci_sequence_number = clset.ci_sequence_number
AND lor.relationship_cd = clset.relationship_cd
AND clset.cl_version = 'RELEASE-4';
SELECT 'X'
FROM igf_sl_loans_all lar
WHERE lar.award_id = cp_n_award_id;
SELECT adisb.disb_num
FROM igf_aw_awd_disb_all adisb
WHERE adisb.award_id=cp_n_award_id
AND NVL(adisb.fund_status,'N') = 'N';
SELECT 'X'
FROM igf_sl_loans_all lar
WHERE lar.award_id = cp_n_award_id;
SELECT adisb.disb_num
FROM igf_aw_awd_disb_all adisb
WHERE adisb.award_id=cp_n_award_id
AND NVL(adisb.fund_status,'N') = 'N';
SELECT loans.loan_number loan_number
,clset.cl_version cl_version
,loans.loan_status loan_status
FROM igf_sl_lor_all lor
,igf_sl_loans_all loans
,igf_aw_award_all awd
,igf_aw_fund_mast_all fmast
,igf_sl_cl_setup_all clset
WHERE loans.loan_id = lor.loan_id
AND loans.award_id = cp_n_award_id
AND lor.prc_type_code IN ('GO','GP')
AND loans.loan_status <> 'S'
AND NVL (loans.loan_chg_status,'*') <> 'S'
AND awd.award_id = loans.award_id
AND fmast.fund_id = awd.fund_id
AND fmast.ci_cal_type = clset.ci_cal_type
AND fmast.ci_sequence_number = clset.ci_sequence_number
AND lor.relationship_cd = clset.relationship_cd ;
SELECT
awd.award_id,
awd.base_id,
fmast.ci_cal_type,
fmast.ci_sequence_number,
lor.relationship_cd
FROM
igf_sl_lor_all lor,
igf_sl_loans_all loans,
igf_aw_award_all awd,
igf_aw_fund_mast_all fmast
WHERE
loans.loan_id = lor.loan_id AND
awd.award_id = loans.award_id AND
fmast.fund_id = awd.fund_id AND
awd.award_id = cp_n_award_id;
SELECT dbresp.disb_num
FROM igf_db_cl_disb_resp dbresp
,igf_sl_loans_all loans
,igf_aw_award_all awd
WHERE dbresp.disb_num = cp_n_disb_num
AND loans.loan_number = dbresp.loan_number
AND awd.award_id = loans.award_id
AND awd.award_id = cp_n_award_id
ORDER BY cdbr_id DESC;
SELECT chg.disbursement_number
FROM igf_sl_clchsn_dtls chg
,igf_sl_loans_all loans
,igf_aw_award_all awd
WHERE chg.disbursement_number = cp_n_disb_num
AND chg.change_record_type_txt = '10'
AND chg.status_code <> ('D')
AND chg.loan_number_txt = loans.loan_number
AND loans.award_id = awd.award_id
AND awd.award_id = cp_n_award_id ;