APPS.IGF_GR_PELL_CALC dependencies on IGF_GR_ATTEND_PELL

Line 307: FROM igf_gr_attend_pell gap, igf_gr_report_pell rep

303: l_att_pell_id igf_gr_pell_setup_all.rep_pell_id%TYPE
304: )
305: IS
306: SELECT rep.reporting_pell_cd
307: FROM igf_gr_attend_pell gap, igf_gr_report_pell rep
308: WHERE gap.ci_cal_type = l_cal_type
309: AND gap.ci_sequence_number = l_seq_num
310: AND gap.attending_pell_cd = l_att_pell_id
311: AND gap.rcampus_id = rep.rcampus_id;

Line 344: l_rep_pell_id igf_gr_attend_pell.attending_pell_cd%TYPE;

340: AND pell.course_cd IS NULL
341: AND pell.version_number IS NULL;
342:
343: l_attend_pell_id igf_gr_report_pell.reporting_pell_cd%TYPE;
344: l_rep_pell_id igf_gr_attend_pell.attending_pell_cd%TYPE;
345: l_ret_status VARCHAR2(30);
346: l_msg_data VARCHAR2(30);
347: l_stu_num VARCHAR2(30);
348: l_ovrd_setup_rec igf_gr_pell_setup_all%ROWTYPE;

Line 355: l_atd_entity_id igf_gr_attend_pell.atd_entity_id_txt%TYPE

351: -- Entity ID declarations
352: CURSOR c_get_rep_entity_id_txt(
353: l_cal_type igs_ca_inst.cal_type%TYPE,
354: l_seq_num igs_ca_inst.sequence_number%TYPE,
355: l_atd_entity_id igf_gr_attend_pell.atd_entity_id_txt%TYPE
356: )
357: IS
358: SELECT rep.rep_entity_id_txt
359: FROM igf_gr_attend_pell gap, igf_gr_report_pell rep

Line 359: FROM igf_gr_attend_pell gap, igf_gr_report_pell rep

355: l_atd_entity_id igf_gr_attend_pell.atd_entity_id_txt%TYPE
356: )
357: IS
358: SELECT rep.rep_entity_id_txt
359: FROM igf_gr_attend_pell gap, igf_gr_report_pell rep
360: WHERE gap.ci_cal_type = l_cal_type
361: AND gap.ci_sequence_number = l_seq_num
362: AND gap.atd_entity_id_txt = l_atd_entity_id
363: AND gap.rcampus_id = rep.rcampus_id;

Line 396: l_rep_entity_id_txt igf_gr_attend_pell.atd_entity_id_txt%TYPE;

392: AND pell.course_cd = l_course_cd
393: AND pell.version_number = l_version_number;
394:
395: l_atd_entity_id_txt igf_gr_report_pell.rep_entity_id_txt%TYPE;
396: l_rep_entity_id_txt igf_gr_attend_pell.atd_entity_id_txt%TYPE;
397: lb_cod_year BOOLEAN;
398:
399: BEGIN
400: