[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT (isir.base_id)
FROM igf_ap_isir_matched isir,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status=cp_depend_stat
AND NVL(isir.auto_zero_efc,'N') <> 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND fa.ci_cal_type =cp_ci_cal_type
AND fa.ci_sequence_number =cp_ci_sequence_number
AND fa.base_id=isir.base_id
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND EXISTS ( SELECT base.base_id
FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att
WHERE base.base_id = isir.base_id
AND base.person_id = att.person_id
AND att.key_program = 'Y'
AND att.course_cd = pv.course_cd
AND att.version_number = pv.version_number
AND (pv.state_financial_aid='Y' OR pv.institutional_financial_aid='Y' OR pv.federal_financial_aid ='Y' )
AND igf_ap_gen_001.get_enrl_program_type(isir.base_id) IN ( SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing = cp_class_standing ));
SELECT COUNT (isir.base_id)
FROM igf_ap_isir_matched isir,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status=cp_depend_stat
AND NVL(isir.auto_zero_efc,'N') <> 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND fa.ci_cal_type =cp_ci_cal_type
AND fa.ci_sequence_number =cp_ci_sequence_number
AND fa.base_id=isir.base_id
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND EXISTS
(SELECT base.base_id
FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att
WHERE base.base_id = isir.base_id
AND base.person_id = att.person_id
AND att.key_program = 'Y'
AND att.course_cd = pv.course_cd
AND att.version_number = pv.version_number
AND (pv.state_financial_aid='Y' OR pv.institutional_financial_aid='Y' OR pv.federal_financial_aid ='Y' )
AND igf_ap_gen_001.get_enrl_program_type(isir.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing =cp_class_standing ));
SELECT COUNT (isir.base_id)
FROM igf_ap_isir_matched isir,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status=cp_depend_stat
AND isir.auto_zero_efc = 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND fa.ci_cal_type =cp_ci_cal_type
AND fa.ci_sequence_number =cp_ci_sequence_number
AND fa.base_id=isir.base_id
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND EXISTS
(
SELECT base.base_id
FROM igf_ap_fa_base_rec_all base,
igs_ps_ver_all pv,
igs_en_stdnt_ps_att att
WHERE base.base_id = isir.base_id
AND base.person_id = att.person_id
AND att.key_program = 'Y'
AND att.course_cd = pv.course_cd
AND att.version_number = pv.version_number
AND (pv.state_financial_aid='Y' OR pv.institutional_financial_aid='Y' OR pv.federal_financial_aid ='Y' )
AND igf_ap_gen_001.get_enrl_program_type(isir.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing =cp_class_standing ));
SELECT COUNT (isir.base_id)
FROM igf_ap_isir_matched isir,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status=cp_depend_stat
AND isir.auto_zero_efc = 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND fa.ci_cal_type =cp_ci_cal_type
AND fa.ci_sequence_number =cp_ci_sequence_number
AND fa.base_id=isir.base_id
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND EXISTS
(
SELECT base.base_id
FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att
WHERE base.base_id = isir.base_id
AND base.person_id = att.person_id
AND att.key_program = 'Y'
AND att.course_cd = pv.course_cd
AND att.version_number = pv.version_number
AND (pv.state_financial_aid='Y' OR pv.institutional_financial_aid='Y' OR pv.federal_financial_aid ='Y' )
AND igf_ap_gen_001.get_enrl_program_type(isir.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing =cp_class_standing ));
SELECT NVL(SUM(awd.paid_amt),0)
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE awd.base_id =isir.base_id
AND fa.base_id =isir.base_id
AND isir.dependency_status =p_depend_stat
AND awd.fed_fund_code =cp_fund_type
AND awd.ci_cal_type =cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND NVL(isir.auto_zero_efc,'N') <> 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND igf_ap_gen_001.get_derived_attend_type(awd.base_id) ='FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT cl.program_type FROM igf_aw_career_map cl
WHERE cl.class_standing IN ('1','2') )
AND isir.fti BETWEEN cp_minvalue AND cp_maxvalue
AND cp_rec_type ='NON_PROFESSIONAL';
SELECT NVL(SUM(awd.paid_amt),0)
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE awd.base_id =isir.base_id
AND fa.base_id =isir.base_id
AND isir.dependency_status =p_depend_stat
AND awd.fed_fund_code =cp_fund_type
AND awd.ci_cal_type =cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND NVL(isir.auto_zero_efc,'N') <> 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND igf_ap_gen_001.get_derived_attend_type(awd.base_id) ='FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing ='3' )
AND cp_rec_type ='PROFESSIONAL';
SELECT NVL(SUM(awd.paid_amt),0)
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE awd.base_id =isir.base_id
AND fa.base_id =isir.base_id
AND isir.dependency_status IN ('I','D')
AND awd.fed_fund_code =cp_fund_type
AND awd.ci_cal_type =cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND NVL(isir.auto_zero_efc,'N') <> 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND NVL(igf_ap_gen_001.get_derived_attend_type(awd.base_id),'N') <>'FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing IN ('1','2','3') )
AND cp_rec_type ='LESS_THAN_FULL_TIME';
SELECT NVL(SUM(awd.paid_amt),0)
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE awd.base_id =isir.base_id
AND fa.base_id =isir.base_id
AND isir.dependency_status IN ('I','D')
AND awd.ci_cal_type =cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND awd.fed_fund_code =cp_fund_type
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND isir.auto_zero_efc = 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND igf_ap_gen_001.get_derived_attend_type(awd.base_id) = 'FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT cl.program_type FROM igf_aw_career_map cl
WHERE cl.class_standing IN ('1','2','3') )
AND cp_rec_type ='AUTO_ZERO';
SELECT COUNT (isir.base_id )
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status =cp_depend_stat
AND fa.base_id =isir.base_id
AND awd.base_id = isir.base_id
AND NVL(isir.auto_zero_efc,'N') <> 'Y'
AND awd.fed_fund_code = cp_fund_type
AND awd.ci_cal_type =cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND igf_ap_gen_001.get_derived_attend_type(awd.base_id) ='FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing IN ('1','2') )
AND isir.fti between cp_minvalue and cp_maxvalue
AND cp_rec_type ='NON_PROFESSIONAL';
SELECT COUNT (isir.base_id )
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status =cp_depend_stat
AND awd.base_id= isir.base_id
AND fa.base_id = isir.base_id
AND awd.fed_fund_code = cp_fund_type
AND awd.ci_cal_type = cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND NVL(isir.auto_zero_efc,'N') <> 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND igf_ap_gen_001.get_derived_attend_type(awd.base_id) ='FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing ='3' )
AND cp_rec_type ='PROFESSIONAL';
SELECT COUNT (isir.base_id )
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status IN ('I','D')
AND awd.base_id = isir.base_id
AND fa.base_id =isir.base_id
AND NVL(isir.auto_zero_efc,'N') <> 'Y'
AND awd.fed_fund_code = cp_fund_type
AND awd.ci_cal_type =cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND NVL(igf_ap_gen_001.get_derived_attend_type(awd.base_id),'N') <> 'FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing IN ('1','2','3') )
AND p_rec_type ='LESS_THAN_FULL_TIME';
SELECT COUNT ( isir.base_id )
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status IN ('I','D')
AND awd.base_id = isir.base_id
AND fa.base_id =isir.base_id
AND awd.fed_fund_code = cp_fund_type
AND awd.ci_cal_type =cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND isir.auto_zero_efc = 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND igf_ap_gen_001.get_derived_attend_type(awd.base_id) = 'FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing IN ('1','2','3') )
AND cp_rec_type ='AUTO_ZERO';
SELECT COUNT ( DISTINCT (isir.base_id ) )
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status = cp_depend_stat
AND awd.base_id = isir.base_id
AND fa.base_id =isir.base_id
AND awd.fed_fund_code IN ('FWS','FSEOG','PRK')
AND awd.ci_cal_type =cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND NVL(isir.auto_zero_efc,'N') <> 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND igf_ap_gen_001.get_derived_attend_type(awd.base_id) ='FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing IN ('1','2') )
AND isir.fti between cp_minvalue and cp_maxvalue
AND cp_rec_type ='NON_PROFESSIONAL';
SELECT COUNT (DISTINCT (isir.base_id ) )
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status =cp_depend_stat
AND awd.base_id = isir.base_id
AND fa.base_id =isir.base_id
AND awd.fed_fund_code IN ('FWS','FSEOG','PRK')
AND awd.ci_cal_type =cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND NVL(isir.auto_zero_efc,'N') <> 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND igf_ap_gen_001.get_derived_attend_type(awd.base_id) ='FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing ='3' )
AND cp_rec_type ='PROFESSIONAL';
SELECT COUNT (DISTINCT(isir.base_id ))
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status IN ('I','D')
AND awd.base_id = isir.base_id
AND fa.base_id = isir.base_id
AND awd.fed_fund_code IN ('FWS','FSEOG','PRK')
AND awd.ci_cal_type =cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND NVL(isir.auto_zero_efc,'N') <> 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND NVL(igf_ap_gen_001.get_derived_attend_type(awd.base_id),'N') <> 'FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing IN ('1','2','3') )
AND cp_rec_type ='LESS_THAN_FULL_TIME';
SELECT COUNT (DISTINCT(isir.base_id ))
FROM igf_ap_isir_matched isir,
igf_aw_award_v awd,
igf_ap_fa_base_rec fa
WHERE isir.dependency_status IN ('I','D')
AND awd.fed_fund_code IN ('FWS','FSEOG','PRK')
AND awd.ci_cal_type =cp_ci_cal_type
AND awd.ci_sequence_number =cp_ci_sequence_number
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND awd.base_id = isir.base_id
AND fa.base_id =isir.base_id
AND isir.auto_zero_efc = 'Y'
AND isir.active_isir ='Y'
AND isir.citizenship_status='1'
AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
AND igf_ap_gen_001.get_derived_attend_type(awd.base_id) = 'FT'
AND igf_ap_gen_001.get_enrl_program_type(awd.base_id) IN
(SELECT cl.program_type
FROM igf_aw_career_map cl
WHERE cl.class_standing IN ('1','2','3') )
AND cp_rec_type ='AUTO_ZERO';
SELECT *
FROM igf_ap_isir_matched
WHERE isir_id = cp_isir_id;
SELECT sys_award_year
FROM igf_ap_batch_aw_map
WHERE ci_cal_type = cp_cal_type
AND ci_sequence_number = cp_seq_num;
SELECT sar.sar_field_number
FROM igf_ap_batch_aw_map map,
Igf_fc_sar_cd_mst sar
WHERE map.ci_cal_type = cp_cal_type
AND map.ci_sequence_number = cp_seq_num
AND sar.sys_award_year = map.sys_award_year
AND sar.sar_field_name = p_field_name ;
SELECT row_id , isirc_id,correction_status
FROM igf_ap_isir_corr
WHERE isir_id = v_isir_id
AND ci_cal_type = v_cal_type
AND ci_sequence_number = v_seq_num
AND sar_field_number = v_sar_fld ;
igf_ap_isir_corr_pkg.insert_row(
X_ROWID => l_rowid,
X_ISIRC_ID => l_isirc_id,
X_ISIR_ID => p_isir_pay.isir_id,
X_CI_SEQUENCE_NUMBER => p_seq_num,
X_CI_CAL_TYPE => p_cal_type,
X_SAR_FIELD_NUMBER => lc_chg_code,
X_ORIGINAL_VALUE => p_field_pay,
X_BATCH_ID => NULL,
X_CORRECTED_VALUE => p_field_corr,
X_CORRECTION_STATUS => p_corr_status,
X_MODE => 'R'
);
igf_ap_isir_corr_pkg.update_row(
X_ROWID => l_rowid,
X_ISIRC_ID => l_chk_corr_exists.isirc_id,
X_ISIR_ID => p_isir_pay.isir_id,
X_CI_SEQUENCE_NUMBER => p_seq_num,
X_CI_CAL_TYPE => p_cal_type,
X_SAR_FIELD_NUMBER => lc_chg_code,
X_ORIGINAL_VALUE => p_field_pay,
X_BATCH_ID => NULL,
X_CORRECTED_VALUE => p_field_corr,
X_CORRECTION_STATUS => lv_corr_status,
X_MODE => 'R'
);
comp_fields( p_isir_corr.SELECTIVE_SERVICE_REG,p_isir_pay.SELECTIVE_SERVICE_REG,'SELECTIVE_SERVICE_REG');
|| cursor resource_cur modified -it does not select resource_fm_i
|| cdcruz 16-Dec-2002 Bug # 2691811
|| Modified the cursor resource_cur , Award Status filter added
|| cdcruz 26-oct-2002 Bug Id 2613546
|| Cursor resource_cur modified to include Familty Contribution calc as well
|| adhawan 25-oct-2002 Bug Id 2613546
|| brajendr 08-May-2002 Bug # 2348285
|| Modified the cursor resource_cur to have award_status condition
|| (reverse chronological order - newest change first)
||
|| Variables description -
|| p_resource_f - SUM of all awards the Student has received
|| p_resource_i - SUM of all Institutional awards the Student has received
|| p_resource_f_fc - SUM of all Replace_EFC awards the Student has received
*/
-- Cursor to determine the Total Awarded Amount for Federal and Institutional Methodology.
-- As part of the Bug 3620500 The resource_f will include all the awards irrespective of the methodology
-- and the replace_fc flad is applicable only to the federal methodology funds.
CURSOR resource_cur IS
SELECT NVL(SUM(NVL(disb.disb_gross_amt,0)),0) resource_f,
NVL(SUM(DECODE(fm.fm_fc_methd,'INSTITUTIONAL',NVL(disb.disb_gross_amt,0),0)),0) resource_i,
NVL(SUM(DECODE(fm.replace_fc,'Y',NVL(disb.disb_gross_amt,0),0)),0) resource_fm_f
FROM igf_aw_awd_disb_all disb,
igf_aw_award_all awd,
igf_aw_fund_mast_all fm,
igf_aw_fund_cat_all fcat,
( SELECT base_id, ld_cal_type, ld_sequence_number
FROM igf_aw_coa_itm_terms
WHERE base_id = p_base_id
GROUP BY base_id,ld_cal_type,ld_sequence_number
) coa
WHERE awd.fund_id = fm.fund_id
AND awd.award_id = disb.award_id
AND fm.fund_code = fcat.fund_code
AND awd.base_id = p_base_id
AND disb.ld_cal_type = coa.ld_cal_type
AND disb.ld_sequence_number = coa.ld_sequence_number
AND awd.base_id = coa.base_id
AND disb.trans_type <> 'C'
AND awd.award_status IN ('OFFERED','ACCEPTED')
AND (
(p_calc_for_subz_loan = 'Y' AND fcat.fed_fund_code NOT IN ('VA30','AMERICORPS')) OR
(p_calc_for_subz_loan = 'N')
);
SELECT NVL(SUM(NVL(disb.disb_gross_amt, 0)), 0) resource_f,
NVL(SUM(DECODE(fm.fm_fc_methd,'INSTITUTIONAL', NVL(disb.disb_gross_amt, 0),0)),0) resource_i,
NVL(SUM(DECODE(fm.replace_fc,'Y', NVL(disb.disb_gross_amt, 0),0)), 0) resource_fm_f
FROM igf_aw_awd_disb_all disb,
igf_aw_award_all awd,
igf_aw_fund_mast_all fm,
igf_aw_fund_cat_all fcat,
igf_ap_fa_base_rec_all fa,
igf_aw_awd_prd_term aprd,
(SELECT base_id,
ld_cal_type,
ld_sequence_number
FROM igf_aw_coa_itm_terms
WHERE base_id = p_base_id
GROUP BY base_id, ld_cal_type, ld_sequence_number) coa
WHERE awd.fund_id = fm.fund_id
AND awd.award_id = disb.award_id
AND fm.fund_code = fcat.fund_code
AND awd.base_id = p_base_id
AND disb.ld_cal_type = coa.ld_cal_type
AND disb.ld_sequence_number = coa.ld_sequence_number
AND awd.base_id = coa.base_id
AND awd.base_id = fa.base_id
AND fa.ci_cal_type = aprd.ci_cal_type
AND fa.ci_sequence_number = aprd.ci_sequence_number
AND disb.ld_cal_type = aprd.ld_cal_type
AND disb.ld_sequence_number = aprd.ld_sequence_number
AND aprd.award_prd_cd = p_awd_prd_code
AND disb.trans_type <> 'C'
AND awd.award_status IN('OFFERED','ACCEPTED')
AND (
(p_calc_for_subz_loan = 'Y' AND fcat.fed_fund_code NOT IN ('VA30','AMERICORPS')) OR
(p_calc_for_subz_loan = 'N')
);