[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT alternate_code
FROM igs_ca_inst
WHERE cal_type = cp_ci_cal_type AND
sequence_NUMBER = cp_ci_sequence_NUMBER;
SELECT meaning, lookup_code FROM igf_lookups_view
WHERE lookup_type='IGF_GE_PARAMETERS' AND
lookup_code IN ('AWARD_YEAR','PERSON_ID_GROUP','PARAMETER_PASS');
SELECT description
FROM igs_pe_persid_group_all
WHERE group_id = lp_per_id;
|| rasahoo 17-NOV-2003 FA 128 - ISIR update 2004-05
|| added new parameter award_fmly_contribution_type to
|| igf_ap_fa_base_rec_pkg.update_row
|| ugummall 26-SEP-2003 FA 126 - Multiple FA Offices
|| added new parameter assoc_org_num to TBH call
|| igf_ap_fa_base_rec_pkg.update_row w.r.t. FA 126
||
|| rasahoo 27-aug-2003 Removed the call to IGF_AP_OSS_PROCESS.GET_OSS_DETAILS
|| as part of obsoletion of FA base record history
|| masehgal 11-Nov-2002 FA 101 - SAP Obsoletion
|| removed packaging hold
*/
--Cursor to find the User Parameter Award Year (which is same as Alternate Code) to display in the Log
CURSOR c_alternate_code(cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
cp_ci_sequence_NUMBER igs_ca_inst.sequence_NUMBER%TYPE) IS
SELECT alternate_code
FROM igs_ca_inst
WHERE cal_type = cp_ci_cal_type AND
sequence_NUMBER = cp_ci_sequence_NUMBER;
SELECT
fa.base_id ,
fa.person_id,
hz.party_number
FROM
igf_ap_fa_base_rec fa,
hz_parties hz
WHERE
fa.ci_cal_type = x_ci_cal_type AND
fa.ci_sequence_NUMBER = x_ci_sequence_NUMBER AND
hz.party_id = fa.person_id;
SELECT
tgrp.group_cd R_code
FROM
igf_aw_target_grp tgrp
WHERE cal_type =cp_cal_type AND
sequence_number =cp_sequence_number AND
group_cd = cp_group_cd;
SELECT
fabase.*
FROM
igf_ap_fa_base_rec fabase
WHERE
fabase.base_id = x_base_id ;
SELECT target_group from igf_ap_fa_base_rec
WHERE base_id=p_base_id;
SELECT description
FROM igs_pe_persid_group_all
WHERE group_id = lp_per_id;
SELECT fa.base_id
FROM igf_ap_fa_base_rec fa
WHERE fa.ci_cal_type = lp_ci_cal_type
AND fa.ci_sequence_number = lp_ci_seq_num
AND fa.person_id = lp_person_id;
OPEN c_stud FOR 'SELECT hz.party_id , hz.party_number FROM
hz_parties hz
WHERE
hz.party_id in ( '||lv_sql_stmt||' ) ' USING p_pergrp_id;
OPEN c_stud FOR 'SELECT hz.party_id , hz.party_number FROM
hz_parties hz
WHERE
hz.party_id in ( '||lv_sql_stmt||' ) ';
igf_ap_fa_base_rec_pkg.update_row(
x_rowid => l_fabase.row_id,
x_base_id => l_fabase.base_id,
x_ci_cal_type => l_fabase.ci_cal_type,
x_person_id => l_fabase.person_id,
x_ci_sequence_NUMBER => l_fabase.ci_sequence_NUMBER,
x_org_id => l_fabase.org_id,
x_coa_pending => l_fabase.coa_pending,
x_verification_process_run => l_fabase.verification_process_run,
x_inst_verif_status_date => l_fabase.inst_verif_status_date,
x_manual_verif_flag => l_fabase.manual_verif_flag,
x_fed_verif_status => l_fabase.fed_verif_status,
x_fed_verif_status_date => l_fabase.fed_verif_status_date,
x_inst_verif_status => l_fabase.inst_verif_status,
x_nslds_eligible => l_fabase.nslds_eligible,
x_ede_correction_batch_id => l_fabase.ede_correction_batch_id,
x_fa_process_status_date => l_fabase.fa_process_status_date,
x_isir_corr_status => l_fabase.isir_corr_status,
x_isir_corr_status_date => l_fabase.isir_corr_status_date,
x_isir_status => l_fabase.isir_status,
x_isir_status_date => l_fabase.isir_status_date,
x_coa_code_f => l_fabase.coa_code_f,
x_coa_code_i => l_fabase.coa_code_i,
x_coa_f => l_fabase.coa_f,
x_coa_i => l_fabase.coa_i,
x_disbursement_hold => l_fabase.disbursement_hold,
x_fa_process_status => l_fabase.fa_process_status,
x_notification_status => l_fabase.notification_status,
x_notification_status_date => l_fabase.notification_status_date,
x_packaging_status => l_fabase.packaging_status,
x_packaging_status_date => l_fabase.packaging_status_date,
x_total_package_accepted => l_fabase.total_package_accepted,
x_total_package_offered => l_fabase.total_package_offered,
x_admstruct_id => l_fabase.admstruct_id,
x_admsegment_1 => l_fabase.admsegment_1,
x_admsegment_2 => l_fabase.admsegment_2,
x_admsegment_3 => l_fabase.admsegment_3,
x_admsegment_4 => l_fabase.admsegment_4,
x_admsegment_5 => l_fabase.admsegment_5,
x_admsegment_6 => l_fabase.admsegment_6,
x_admsegment_7 => l_fabase.admsegment_7,
x_admsegment_8 => l_fabase.admsegment_8,
x_admsegment_9 => l_fabase.admsegment_9,
x_admsegment_10 => l_fabase.admsegment_10,
x_admsegment_11 => l_fabase.admsegment_11,
x_admsegment_12 => l_fabase.admsegment_12,
x_admsegment_13 => l_fabase.admsegment_13,
x_admsegment_14 => l_fabase.admsegment_14,
x_admsegment_15 => l_fabase.admsegment_15,
x_admsegment_16 => l_fabase.admsegment_16,
x_admsegment_17 => l_fabase.admsegment_17,
x_admsegment_18 => l_fabase.admsegment_18,
x_admsegment_19 => l_fabase.admsegment_19,
x_admsegment_20 => l_fabase.admsegment_20,
x_packstruct_id => l_fabase.packstruct_id,
x_packsegment_1 => l_fabase.packsegment_1,
x_packsegment_2 => l_fabase.packsegment_2,
x_packsegment_3 => l_fabase.packsegment_3,
x_packsegment_4 => l_fabase.packsegment_4,
x_packsegment_5 => l_fabase.packsegment_5,
x_packsegment_6 => l_fabase.packsegment_6,
x_packsegment_7 => l_fabase.packsegment_7,
x_packsegment_8 => l_fabase.packsegment_8,
x_packsegment_9 => l_fabase.packsegment_9,
x_packsegment_10 => l_fabase.packsegment_10,
x_packsegment_11 => l_fabase.packsegment_11,
x_packsegment_12 => l_fabase.packsegment_12,
x_packsegment_13 => l_fabase.packsegment_13,
x_packsegment_14 => l_fabase.packsegment_14,
x_packsegment_15 => l_fabase.packsegment_15,
x_packsegment_16 => l_fabase.packsegment_16,
x_packsegment_17 => l_fabase.packsegment_17,
x_packsegment_18 => l_fabase.packsegment_18,
x_packsegment_19 => l_fabase.packsegment_19,
x_packsegment_20 => l_fabase.packsegment_20,
x_miscstruct_id => l_fabase.miscstruct_id,
x_miscsegment_1 => l_fabase.miscsegment_1,
x_miscsegment_2 => l_fabase.miscsegment_2,
x_miscsegment_3 => l_fabase.miscsegment_3,
x_miscsegment_4 => l_fabase.miscsegment_4,
x_miscsegment_5 => l_fabase.miscsegment_5,
x_miscsegment_6 => l_fabase.miscsegment_6,
x_miscsegment_7 => l_fabase.miscsegment_7,
x_miscsegment_8 => l_fabase.miscsegment_8,
x_miscsegment_9 => l_fabase.miscsegment_9,
x_miscsegment_10 => l_fabase.miscsegment_10,
x_miscsegment_11 => l_fabase.miscsegment_11,
x_miscsegment_12 => l_fabase.miscsegment_12,
x_miscsegment_13 => l_fabase.miscsegment_13,
x_miscsegment_14 => l_fabase.miscsegment_14,
x_miscsegment_15 => l_fabase.miscsegment_15,
x_miscsegment_16 => l_fabase.miscsegment_16,
x_miscsegment_17 => l_fabase.miscsegment_17,
x_miscsegment_18 => l_fabase.miscsegment_18,
x_miscsegment_19 => l_fabase.miscsegment_19,
x_miscsegment_20 => l_fabase.miscsegment_20,
x_prof_judgement_flg => l_fabase.prof_judgement_flg,
x_nslds_data_override_flg => l_fabase.nslds_data_override_flg ,
x_target_group => p_grp_code,
x_coa_fixed => l_fabase.coa_fixed,
x_coa_pell => l_fabase.coa_pell,
x_profile_status => l_fabase.profile_status,
x_profile_status_date => l_fabase.profile_status_date,
x_profile_fc => l_fabase.profile_fc,
x_manual_disb_hold => l_fabase.manual_disb_hold,
x_tolerance_amount => l_fabase.tolerance_amount,
x_pell_alt_expense => l_fabase.pell_alt_expense,
x_mode => 'R',
x_assoc_org_num => l_fabase.assoc_org_num,
x_award_fmly_contribution_type => l_fabase.award_fmly_contribution_type,
x_isir_locked_by => l_fabase.isir_locked_by,
x_adnl_unsub_loan_elig_flag => l_fabase.adnl_unsub_loan_elig_flag,
x_lock_awd_flag => l_fabase.lock_awd_flag,
x_lock_coa_flag => l_fabase.lock_coa_flag
);