APPS.IGF_GR_GEN_XML dependencies on IGS_CA_INST

Line 180: CURSOR cur_get_base ( p_cal_type igs_ca_inst_all.cal_type%TYPE,

176: FROM IGS_PE_PERSON_BASE_V
177: WHERE person_id = p_person_id;
178: get_pers_num_rec cur_get_pers_num%ROWTYPE;
179:
180: CURSOR cur_get_base ( p_cal_type igs_ca_inst_all.cal_type%TYPE,
181: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
182: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
183: SELECT base_id
184: FROM IGF_AP_FA_BASE_REC_ALL

Line 181: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,

177: WHERE person_id = p_person_id;
178: get_pers_num_rec cur_get_pers_num%ROWTYPE;
179:
180: CURSOR cur_get_base ( p_cal_type igs_ca_inst_all.cal_type%TYPE,
181: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
182: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
183: SELECT base_id
184: FROM IGF_AP_FA_BASE_REC_ALL
185: WHERE person_id = p_person_id

Line 324: CURSOR cur_awd_year ( cp_cal_type igs_ca_inst.cal_type%TYPE,

320: (reverse chronological order - newest change first)
321: ***************************************************************/
322:
323: -- To get award year details from System award year mappings table.
324: CURSOR cur_awd_year ( cp_cal_type igs_ca_inst.cal_type%TYPE,
325: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
326: SELECT bam.award_year_status_code,
327: bam.pell_participant_code,
328: bam.sys_award_year

Line 325: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS

321: ***************************************************************/
322:
323: -- To get award year details from System award year mappings table.
324: CURSOR cur_awd_year ( cp_cal_type igs_ca_inst.cal_type%TYPE,
325: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
326: SELECT bam.award_year_status_code,
327: bam.pell_participant_code,
328: bam.sys_award_year
329: FROM IGF_AP_BATCH_AW_MAP bam

Line 335: CURSOR cur_source_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,

331: AND bam.ci_sequence_number = cp_sequence_number;
332: rec_awd_year cur_awd_year%ROWTYPE;
333:
334: -- To get source entity id from Pell ID/Entity ID relationships.
335: CURSOR cur_source_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
336: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
337: cp_source_entity_id igf_gr_report_pell.rep_entity_id_txt%TYPE) IS
338: SELECT 'x'
339: FROM IGF_GR_REPORT_PELL rep

Line 336: cp_sequence_number igs_ca_inst.sequence_number%TYPE,

332: rec_awd_year cur_awd_year%ROWTYPE;
333:
334: -- To get source entity id from Pell ID/Entity ID relationships.
335: CURSOR cur_source_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
336: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
337: cp_source_entity_id igf_gr_report_pell.rep_entity_id_txt%TYPE) IS
338: SELECT 'x'
339: FROM IGF_GR_REPORT_PELL rep
340: WHERE rep.ci_cal_type = cp_cal_type

Line 345: CURSOR cur_rep_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,

341: AND rep.ci_sequence_number = cp_sequence_number
342: AND rep.rep_entity_id_txt = cp_source_entity_id;
343:
344: -- To check pell origination records exists or not with given report entity id.
345: CURSOR cur_rep_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
346: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
347: cp_report_entity_id igf_gr_rfms.rep_entity_id_txt%TYPE ) IS
348: SELECT rfms.origination_id
349: FROM IGF_GR_RFMS rfms

Line 346: cp_sequence_number igs_ca_inst.sequence_number%TYPE,

342: AND rep.rep_entity_id_txt = cp_source_entity_id;
343:
344: -- To check pell origination records exists or not with given report entity id.
345: CURSOR cur_rep_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
346: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
347: cp_report_entity_id igf_gr_rfms.rep_entity_id_txt%TYPE ) IS
348: SELECT rfms.origination_id
349: FROM IGF_GR_RFMS rfms
350: WHERE rfms.ci_cal_type = cp_cal_type

Line 355: CURSOR cur_attd_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,

351: AND rfms.ci_sequence_number = cp_sequence_number
352: AND rfms.rep_entity_id_txt = cp_report_entity_id;
353:
354: -- To check pell origination records exists or not with given report and attend entity ids.
355: CURSOR cur_attd_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
356: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
357: cp_report_entity_id igf_gr_rfms.rep_entity_id_txt%TYPE,
358: cp_attend_entity_id igf_gr_rfms.atd_entity_id_txt%TYPE ) IS
359: SELECT rfms.origination_id

Line 356: cp_sequence_number igs_ca_inst.sequence_number%TYPE,

352: AND rfms.rep_entity_id_txt = cp_report_entity_id;
353:
354: -- To check pell origination records exists or not with given report and attend entity ids.
355: CURSOR cur_attd_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
356: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
357: cp_report_entity_id igf_gr_rfms.rep_entity_id_txt%TYPE,
358: cp_attend_entity_id igf_gr_rfms.atd_entity_id_txt%TYPE ) IS
359: SELECT rfms.origination_id
360: FROM IGF_GR_RFMS rfms

Line 373: CURSOR cur_person_number ( cp_cal_type igs_ca_inst.cal_type%TYPE,

369: FROM IGF_AP_FA_BASE_REC_ALL fabase
370: WHERE fabase.base_id = cp_base_id;
371:
372: -- To check pell origination records exists or not with given person.
373: CURSOR cur_person_number ( cp_cal_type igs_ca_inst.cal_type%TYPE,
374: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
375: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
376: SELECT 'x'
377: FROM IGF_GR_RFMS rfms

Line 374: cp_sequence_number igs_ca_inst.sequence_number%TYPE,

370: WHERE fabase.base_id = cp_base_id;
371:
372: -- To check pell origination records exists or not with given person.
373: CURSOR cur_person_number ( cp_cal_type igs_ca_inst.cal_type%TYPE,
374: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
375: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
376: SELECT 'x'
377: FROM IGF_GR_RFMS rfms
378: WHERE rfms.ci_cal_type = cp_cal_type