[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
IS SELECT
base_id, ci_cal_type, ci_sequence_number
FROM igf_sl_loans_v WHERE loan_number = cp_loan_number;
IS SELECT relationship_cd
FROM igf_sl_lor_v WHERE loan_number = cp_loan_number;
SELECT fund_code
FROM
igf_aw_fund_mast
WHERE
fund_id = p_fund_id;
SELECT group_cd
FROM igs_pe_persid_group_all
WHERE group_id = p_per_grp_id;
SELECT meaning, lookup_code
FROM igf_lookups_view
WHERE lookup_type = 'IGF_GE_PARAMETERS'
AND lookup_code IN ('PARAMETER_PASS',
'AWARD_YEAR',
'RUN_FOR',
'PERSON_ID_GROUP',
'PERSON_NUMBER',
'FUND_CODE',
'LOG_DETAIL'
);
SELECT
start_dt,end_dt
FROM
igs_ca_inst
WHERE
p_ld_seq_num = sequence_number;
SELECT fund_code fdesc
FROM igf_aw_fund_mast
WHERE
fund_id = p_fund_id;
SELECT person_number
FROM igs_pe_person_base_v
WHERE
person_id = p_person_id;
SELECT
base_id
FROM
igf_ap_fa_base_rec
WHERE
person_id = p_person_id AND
ci_cal_type = p_cal_type AND
ci_sequence_number = p_sequence_number;
SELECT NVL(MAX(disb_seq_num),0) + 1 disb_seq_num
FROM
igf_db_awd_disb_dtl dtl
WHERE
dtl.award_id = p_award_id AND
dtl.disb_num = p_disb_num;
SELECT *
FROM
igf_aw_awd_disb adisb
WHERE
adisb.row_id = p_row_id
FOR UPDATE OF elig_status NOWAIT;
CURSOR cur_update_fund (p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
IS
SELECT *
FROM
igf_aw_fund_mast
WHERE
fund_id = p_fund_id
FOR UPDATE OF total_disbursed NOWAIT;
update_fund_rec cur_update_fund%ROWTYPE;
OPEN cur_update_fund(p_fund_id);
FETCH cur_update_fund INTO update_fund_rec;
CLOSE cur_update_fund;
igf_db_awd_disb_dtl_pkg.insert_row(x_rowid => lv_rowid,
x_award_id => disb_dtl_rec.award_id ,
x_disb_num => disb_dtl_rec.disb_num ,
x_disb_seq_num => disb_dtl_rec.disb_seq_num ,
x_disb_gross_amt => disb_dtl_rec.disb_gross_amt ,
x_fee_1 => disb_dtl_rec.fee_1 ,
x_fee_2 => disb_dtl_rec.fee_2 ,
x_disb_net_amt => disb_dtl_rec.disb_net_amt ,
x_disb_adj_amt => disb_dtl_rec.disb_adj_amt ,
x_disb_date => disb_dtl_rec.disb_date ,
x_fee_paid_1 => disb_dtl_rec.fee_paid_1 ,
x_fee_paid_2 => disb_dtl_rec.fee_paid_2 ,
x_disb_activity => disb_dtl_rec.disb_activity ,
x_disb_batch_id => NULL,
x_disb_ack_date => NULL,
x_booking_batch_id => NULL,
x_booked_date => NULL,
x_disb_status => NULL,
x_disb_status_date => NULL,
x_sf_status => disb_dtl_rec.sf_status ,
x_sf_status_date => disb_dtl_rec.sf_status_date ,
x_sf_invoice_num => disb_dtl_rec.sf_invoice_num ,
x_spnsr_credit_id => disb_dtl_rec.spnsr_credit_id ,
x_spnsr_charge_id => disb_dtl_rec.spnsr_charge_id ,
x_sf_credit_id => disb_dtl_rec.sf_credit_id ,
x_error_desc => disb_dtl_rec.error_desc ,
x_mode => 'R',
x_notification_date => disb_dtl_rec.notification_date,
x_interest_rebate_amt => NULL,
x_ld_cal_type => get_adisb_rec.ld_cal_type,
x_ld_sequence_number => get_adisb_rec.ld_sequence_number
);
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 => get_adisb_rec.fee_1 ,
x_fee_2 => get_adisb_rec.fee_2 ,
x_disb_net_amt => get_adisb_rec.disb_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_attendance_type_code => get_adisb_rec.attendance_type_code,
x_base_attendance_type_code => get_adisb_rec.base_attendance_type_code,
x_mode => 'R',
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 *
FROM igf_aw_awd_disb adisb
WHERE
adisb.row_id = p_row_id
FOR UPDATE OF disb_num NOWAIT;
SELECT origination_id, orig_action_code
FROM igf_gr_rfms
WHERE
award_id = p_award_id
FOR UPDATE OF origination_id NOWAIT;
SELECT disb_ack_act_status
FROM igf_gr_rfms_disb
WHERE
origination_id = p_origination_id AND
disb_ref_num = p_disb_num;
SELECT disb_date,disb_num
FROM igf_aw_awd_disb adisb
WHERE
adisb.award_id = p_award_id AND
disb_num =
( SELECT MAX(disb_num) FROM igf_aw_awd_disb WHERE
award_id = p_award_id);
SELECT
COUNT(disb_seq_num) adj_cnt
FROM
igf_db_awd_disb_dtl
WHERE
award_id = p_award_id AND
disb_num = p_disb_num AND
disb_status = 'S';
SELECT award_status
FROM igf_aw_award_all
WHERE award_id = p_award_id;
SELECT fmast.ci_cal_type, fmast.ci_sequence_number
FROM igf_aw_fund_mast_all fmast,
igf_aw_award_all awd
WHERE fmast.fund_id = awd.fund_id AND
awd.award_id = cp_awd_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 => NVL(l_disb_gross_amt,0) ,
x_fee_1 => NVL(l_orig_fee,0) ,
x_fee_2 => NVL(l_guar_fee,0) ,
x_disb_net_amt => NVL(l_disb_net_amt,0) ,
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 => NVL(l_disb_accepted_amt,0) ,
x_disb_paid_amt => get_adisb_rec.disb_paid_amt ,
x_rvsn_id => get_adisb_rec.rvsn_id ,
x_int_rebate_amt => NVL(l_int_rebate_amt,0) ,
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_attendance_type_code => get_adisb_rec.attendance_type_code,
x_base_attendance_type_code => get_adisb_rec.base_attendance_type_code,
x_mode => 'R',
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
);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','inserting to igf_aw_awd_disb with award_id '||get_adisb_rec.award_id);
igf_aw_awd_disb_pkg.insert_row( x_rowid => lv_rowid ,
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 => -1 * get_adisb_rec.disb_gross_amt,--Negative value
x_fee_1 => get_adisb_rec.fee_1 ,
x_fee_2 => get_adisb_rec.fee_2 ,
x_disb_net_amt => -1 * get_adisb_rec.disb_net_amt ,--Negative value
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 => -1 * get_adisb_rec.disb_accepted_amt ,--Negative value
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_attendance_type_code => get_adisb_rec.attendance_type_code,
x_base_attendance_type_code => get_adisb_rec.base_attendance_type_code,
x_mode => 'R',
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
);
PROCEDURE delete_pays
AS
--------------------------------------------------------------------------------------------
--
-- Created By : sjadhav
-- Date Created By : Jan 07,2002
-- Purpose : This routine truncates pays only data used in
-- previous run of eligibility checks
--
--------------------------------------------------------------------------------------------
CURSOR cur_pays_prg IS
SELECT
db.rowid row_id,db.*
FROM
igf_db_pays_prg_t db;
igf_db_pays_prg_t_pkg.delete_row(pays_prg_rec.row_id);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.delete_pays.debug','deleted from igf_db_pays_prg_t');
fnd_message.set_token('NAME','IGF_DB_DISB.DELETE_PAYS '||SQLERRM);
END delete_pays;
SELECT manual_disb_hold,
fa_process_status
FROM igf_ap_fa_base_rec
WHERE base_id = cp_base_id;
SELECT ver_app_stat_override
FROM igf_aw_fund_mast
WHERE fund_id = cp_fund_id;
SELECT fed_verif_status
FROM igf_ap_fa_base_rec fab
WHERE fab.base_id = p_base_id
AND fab.fed_verif_status IN ('ACCURATE','CALCULATED','NOTVERIFIED','NOTSELECTED',
'REPROCESSED','TOLERANCE','WAIVED');
SELECT 'x'
FROM igf_aw_fund_mast_all fmast,
igf_aw_fund_td_map_all fndtd,
igf_ap_td_item_inst_all tdinst,
igf_ap_td_item_mst_all tdmst
WHERE fmast.fund_id = cp_fund_id
AND tdinst.base_id = cp_base_id
AND fndtd.fund_id = fmast.fund_id
AND fndtd.item_sequence_number = tdinst.item_sequence_number
AND fndtd.item_sequence_number = tdmst.todo_number
AND NVL(tdmst.career_item,'N') = 'N'
AND tdinst.status <> cp_status
AND tdinst.inactive_flag <> cp_inactive
UNION
SELECT 'x'
FROM igf_aw_fund_mast_all fmast,
igf_aw_fund_td_map_all fndtd,
igf_ap_td_item_inst_v tdinst,
igf_ap_td_item_mst_all tdmst,
igf_ap_fa_base_rec_all fa
WHERE fmast.fund_id = cp_fund_id
AND fa.base_id = cp_base_id
AND fa.person_id = tdinst.person_id
AND fndtd.fund_id = fmast.fund_id
AND fndtd.item_sequence_number = tdinst.item_sequence_number
AND fndtd.item_sequence_number = tdmst.todo_number
AND NVL(tdmst.career_item,'N') = 'Y'
AND tdinst.status <> cp_status
AND tdinst.inactive_flag <> cp_inactive;
PROCEDURE insert_pays_prg_uts(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
p_acad_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)
AS
--------------------------------------------------------------------------------------------
--
-- Created By : sjadhav
-- Date Created By : Jan 07,2002
-- Purpose : This routine inserts Pays Only Programs, Units into
-- temporary table igf_db_pays_prg_t
--
--------------------------------------------------------------------------------------------
-- Get all the teaching periods for the academic calendar instance
CURSOR cur_get_acad_tp (p_acad_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
p_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
IS
SELECT
sub_cal_type tp_cal_type,
sub_ci_sequence_number tp_sequence_number
FROM
igs_ca_inst_rel cr_1,
igs_ca_type ct_1,
igs_ca_type ct_2
WHERE
ct_1.cal_type = cr_1.sup_cal_type AND
ct_1.s_cal_cat = 'ACADEMIC' AND
ct_2.cal_type = cr_1.sub_cal_type AND
ct_2.s_cal_cat = 'TEACHING' AND
cr_1.sup_cal_type = p_acad_ci_cal_type AND
cr_1.sup_ci_sequence_number = p_acad_ci_sequence_number;
SELECT
pg.course_cd prg_course_cd,
pg.version_number prg_ver_num,
su.unit_cd unit_course_cd ,
su.version_number unit_ver_num
FROM
igs_en_su_attempt su,
igs_en_stdnt_ps_att pg
WHERE
su.person_id = p_person_id AND
pg.person_id = su.person_id AND
su.unit_attempt_status IN ('COMPLETED','ENROLLED','DUPLICATE') AND
su.cal_type = p_tp_cal_type AND
su.ci_sequence_number = p_tp_sequence_number AND
pg.cal_type = p_acad_cal_type AND
pg.course_cd(+) = su.course_cd;
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','p_acad_cal_type:'||p_acad_cal_type);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','p_acad_ci_seq_num:'||p_acad_ci_seq_num);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id('||p_base_id||'):'||igf_gr_gen.get_person_id(p_base_id));
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:'||get_acad_tp_rec.tp_cal_type);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'||get_acad_tp_rec.tp_sequence_number);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:'||dbpays_rec.program_cd);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:'||dbpays_rec.prg_ver_num);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:'||dbpays_rec.unit_cd);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:'||dbpays_rec.unit_ver_num);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','inserting to igf_db_pays_prg_t');
igf_db_pays_prg_t_pkg.insert_row(
x_rowid => lv_rowid,
x_dbpays_id => dbpays_rec.dbpays_id,
x_base_id => dbpays_rec.base_id,
x_program_cd => dbpays_rec.program_cd,
x_prg_ver_num => dbpays_rec.prg_ver_num,
x_unit_cd => dbpays_rec.unit_cd,
x_unit_ver_num => dbpays_rec.unit_ver_num,
x_mode => 'R'
);
fnd_message.set_token('NAME','IGF_DB_DISB.INSERT_PAYS_PRG_UTS '||SQLERRM);
END insert_pays_prg_uts;
SELECT
program_cd,
prg_ver_num
FROM
igf_db_pays_prg_t
WHERE
base_id = p_base_id
INTERSECT
SELECT
course_cd,
version_number
FROM
igf_aw_fund_prg_v fprg
WHERE
fprg.fund_id = p_fund_id;
SELECT
course_cd,
version_number
FROM
igf_aw_fund_prg_v fprg
WHERE
fprg.fund_id = p_fund_id;
SELECT
unit_cd,
unit_ver_num
FROM
igf_db_pays_prg_t
WHERE
base_id = p_base_id
INTERSECT
SELECT
unit_cd,
version_number
FROM
igf_aw_fund_unit_v funit
WHERE
funit.fund_id = p_fund_id;
SELECT
unit_cd,
version_number
FROM
igf_aw_fund_unit_v funit
WHERE
funit.fund_id = p_fund_id;
SELECT isir.nslds_match_flag,
fabase.nslds_data_override_flg
FROM igf_ap_isir_matched isir,
igf_ap_fa_base_rec_all fabase
WHERE isir.base_id = p_base_id
AND isir.active_isir = 'Y'
AND isir.base_id = fabase.base_id;
SELECT
fee_class
FROM
igf_aw_fund_feeclas
WHERE
fund_id = p_fund_id;
SELECT
fee_class
FROM
igf_aw_fund_feeclas
WHERE
fund_id = p_fund_id
INTERSECT
SELECT
fee_class
FROM
igs_fi_inv_igf_v
WHERE
fee_cal_type = p_fee_cal_type AND
fee_ci_sequence_number = p_fee_ci_sequence_number AND
person_id = p_person_id;
SELECT
upper_enr_load_range
FROM
igs_en_atd_type_load
WHERE
cal_type = p_ld_cal_type AND
attendance_type = p_min_att_type;
SELECT
adisb.* ,
awd.base_id,
fmast.ci_cal_type,
fmast.ci_sequence_number,
fmast.fund_id,
cat.fed_fund_code
FROM
igf_aw_awd_disb adisb,
igf_aw_fund_mast fmast,
igf_aw_award awd,
igf_aw_fund_cat cat
WHERE
adisb.award_id = awd.award_id AND
fmast.fund_code = cat.fund_code AND
fmast.fund_id = awd.fund_id AND
awd.base_id = p_base_id AND
awd.fund_id = NVL(p_fund_id,awd.fund_id) AND
adisb.trans_type = 'A' AND
NVL(adisb.verf_enfr_dt,TRUNC(SYSDATE)+1) <= SYSDATE AND
awd.award_status = 'ACCEPTED' AND
cat.fed_fund_code NOT IN ('FWS','SPNSR') AND
cat.sys_fund_type NOT IN ('WORK','SPONSOR') AND
adisb.elig_status <> 'V' -- Elig Status NOT VERIFIED
FOR UPDATE OF elig_status NOWAIT;
SELECT *
FROM igf_aw_awd_disb adisb
WHERE
adisb.row_id = p_row_id
FOR UPDATE OF elig_status NOWAIT;
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 => get_adisb_rec.fee_1 ,
x_fee_2 => get_adisb_rec.fee_2 ,
x_disb_net_amt => get_adisb_rec.disb_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_attendance_type_code => get_adisb_rec.attendance_type_code,
x_base_attendance_type_code => get_adisb_rec.base_attendance_type_code,
x_mode => 'R',
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
adisb.ROWID row_id,
adisb.*,
awd.base_id,
awd.accepted_amt,
fmast.ci_cal_type,
fmast.ci_sequence_number,
fmast.fund_id,
fmast.fund_code,
fmast.send_without_doc,
fmast.ver_app_stat_override,
NVL(fmast.org_record_req,'N') org_record_req,
NVL(fmast.disb_record_req,'N') disb_record_req,
NVL(fmast.prom_note_req,'N') prom_note_req,
NVL(fmast.fund_recv_reqd,'N') fund_recv_req,
fmast.fee_type fee_type,
cat.fed_fund_code
FROM
igf_aw_awd_disb_all adisb,
igf_aw_fund_mast_all fmast,
igf_aw_award_all awd,
igf_aw_fund_cat_all cat
WHERE
adisb.award_id = awd.award_id AND
fmast.fund_code = cat.fund_code AND
fmast.fund_id = awd.fund_id AND
awd.base_id = p_base_id AND
awd.fund_id = NVL(p_fund_id,awd.fund_id) AND
adisb.award_id = NVL(p_award_id,adisb.award_id) AND
adisb.disb_num = NVL(p_disb_num,adisb.disb_num) AND
adisb.trans_type = 'P' AND
adisb.disb_date <= SYSDATE AND
NVL(adisb.manual_hold_ind,'N') = 'N' AND
NVL(fmast.disburse_fund,'N') = 'Y' AND
NVL(fmast.discontinue_fund,'N') <> 'Y' AND
awd.award_status = 'ACCEPTED' AND
cat.fed_fund_code NOT IN ('FWS','SPNSR') AND
cat.sys_fund_type NOT IN ('WORK','SPONSOR')
ORDER BY
awd.base_id,awd.award_id,adisb.disb_num;
SELECT
loan_id, loan_number, loan_status, active
FROM
igf_sl_loans
WHERE
award_id = p_award_id;
SELECT
origination_id,
NVL(pnote_status,'N') pnote_status,
NVL(mpn_confirm_code,'N') mpn_confirm_code
FROM
igf_sl_lor
WHERE
loan_id = p_loan_id;
SELECT
origination_id,orig_action_code,efc
FROM
igf_gr_rfms
WHERE
award_id = p_award_id;
SELECT
disb_ack_act_status
FROM
igf_gr_rfms_disb
WHERE
origination_id = p_origination_id AND
disb_ref_num = p_disb_num;
SELECT
NVL(fed_verif_status,'*') fed_verif_status
FROM
igf_ap_fa_base_rec
WHERE
base_id = p_base_id;
SELECT SUM(disb.disb_gross_amt) term_total
FROM igf_aw_awd_disb_all disb,
igf_aw_award_all awd
WHERE disb.trans_type <> 'C'
AND awd.award_id = disb.award_id
AND awd.award_id = p_award_id
AND disb.ld_cal_type = p_ld_cal_type
AND disb.ld_sequence_number = p_ld_seq_num;
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling delete_pays');
delete_pays();
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called delete_pays');
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','calling insert_pays_prg_uts');
insert_pays_prg_uts(awd_disb_rec.base_id,
lv_acad_cal_type,ln_acad_seq_num);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','called insert_pays_prg_uts');
SELECT alternate_code
FROM igs_ca_inst
WHERE cal_type = cp_cal_type
AND sequence_number = cp_seq_number;
SELECT group_cd
FROM igs_pe_persid_group
WHERE group_id = p_per_grp_id;
SELECT
DISTINCT
awd.base_id,
fcat.fed_fund_code
FROM
igf_aw_award awd,
igf_aw_fund_mast fmast,
igf_aw_fund_cat fcat
WHERE
awd.fund_id = p_fund_id AND
awd.fund_id = fmast.fund_id AND
fmast.fund_code = fcat.fund_code AND
awd.award_status = 'ACCEPTED';
OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_per_grp_id;
OPEN cur_per_grp FOR ' SELECT party_id FROM hz_parties WHERE party_id IN (' || l_list || ') ';