APPS.IGF_GR_PELL_CALC dependencies on IGF_GR_REPORT_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 343: l_attend_pell_id igf_gr_report_pell.reporting_pell_cd%TYPE;

339: AND pell.rep_pell_id = l_reporting_pell_id
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);

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 395: l_atd_entity_id_txt igf_gr_report_pell.rep_entity_id_txt%TYPE;

391: AND pell.rep_entity_id_txt = l_rep_entity_id
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