APPS.IGF_AW_GEN_002 dependencies on IGF_AP_FA_BASE_REC_ALL

Line 89: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att

85: AND fa.ci_sequence_number =cp_ci_sequence_number
86: AND fa.base_id=isir.base_id
87: AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
88: AND EXISTS ( SELECT base.base_id
89: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att
90: WHERE base.base_id = isir.base_id
91: AND base.person_id = att.person_id
92: AND att.key_program = 'Y'
93: AND att.course_cd = pv.course_cd

Line 125: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att

121: AND fa.base_id=isir.base_id
122: AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
123: AND EXISTS
124: (SELECT base.base_id
125: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att
126: WHERE base.base_id = isir.base_id
127: AND base.person_id = att.person_id
128: AND att.key_program = 'Y'
129: AND att.course_cd = pv.course_cd

Line 164: FROM igf_ap_fa_base_rec_all base,

160: AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
161: AND EXISTS
162: (
163: SELECT base.base_id
164: FROM igf_ap_fa_base_rec_all base,
165: igs_ps_ver_all pv,
166: igs_en_stdnt_ps_att att
167: WHERE base.base_id = isir.base_id
168: AND base.person_id = att.person_id

Line 202: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att

198: AND DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) IS NOT NULL
199: AND EXISTS
200: (
201: SELECT base.base_id
202: FROM igf_ap_fa_base_rec_all base,igs_ps_ver_all pv,igs_en_stdnt_ps_att att
203: WHERE base.base_id = isir.base_id
204: AND base.person_id = att.person_id
205: AND att.key_program = 'Y'
206: AND att.course_cd = pv.course_cd

Line 1257: p_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

1253: --Procedure for Comparing ISIR Applications
1254: PROCEDURE compare_isirs(
1255: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
1256: p_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
1257: p_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1258: p_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1259: p_corr_status igf_ap_isir_corr.correction_status%TYPE
1260: ) AS
1261:

Line 1258: p_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

1254: PROCEDURE compare_isirs(
1255: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
1256: p_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
1257: p_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1258: p_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1259: p_corr_status igf_ap_isir_corr.correction_status%TYPE
1260: ) AS
1261:
1262: /***************************************************************

Line 1286: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

1282: p_isir_corr c_get_org_isir%ROWTYPE;
1283: p_isir_pay c_get_org_isir%ROWTYPE;
1284: -- Get system award details
1285: CURSOR c_sys_awd_yr(
1286: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1287: cp_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
1288: ) IS
1289: SELECT sys_award_year
1290: FROM igf_ap_batch_aw_map

Line 1287: cp_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

1283: p_isir_pay c_get_org_isir%ROWTYPE;
1284: -- Get system award details
1285: CURSOR c_sys_awd_yr(
1286: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1287: cp_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
1288: ) IS
1289: SELECT sys_award_year
1290: FROM igf_ap_batch_aw_map
1291: WHERE ci_cal_type = cp_cal_type

Line 1667: igf_ap_fa_base_rec_all fa,

1663: FROM igf_aw_awd_disb_all disb,
1664: igf_aw_award_all awd,
1665: igf_aw_fund_mast_all fm,
1666: igf_aw_fund_cat_all fcat,
1667: igf_ap_fa_base_rec_all fa,
1668: igf_aw_awd_prd_term aprd,
1669: (SELECT base_id,
1670: ld_cal_type,
1671: ld_sequence_number