APPS.IGF_GR_RFMS_DISB_ORIG dependencies on IGF_GR_REPORT_PELL

Line 557: cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,

553: cur_pymnt_isir_rec cur_pymnt_isir%rowtype;
554:
555: -- Cursor to check attending pell id is a child of reporting pell id
556: CURSOR cur_attending_pell(
557: cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,
558: cp_ci_sequence_number igf_gr_report_pell.ci_sequence_number%TYPE,
559: cp_reporting_pell igf_gr_report_pell.reporting_pell_cd%TYPE,
560: cp_attending_pell igf_gr_attend_pell.attending_pell_cd%TYPE
561: ) IS

Line 558: cp_ci_sequence_number igf_gr_report_pell.ci_sequence_number%TYPE,

554:
555: -- Cursor to check attending pell id is a child of reporting pell id
556: CURSOR cur_attending_pell(
557: cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,
558: cp_ci_sequence_number igf_gr_report_pell.ci_sequence_number%TYPE,
559: cp_reporting_pell igf_gr_report_pell.reporting_pell_cd%TYPE,
560: cp_attending_pell igf_gr_attend_pell.attending_pell_cd%TYPE
561: ) IS
562: SELECT 'Y'

Line 559: cp_reporting_pell igf_gr_report_pell.reporting_pell_cd%TYPE,

555: -- Cursor to check attending pell id is a child of reporting pell id
556: CURSOR cur_attending_pell(
557: cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,
558: cp_ci_sequence_number igf_gr_report_pell.ci_sequence_number%TYPE,
559: cp_reporting_pell igf_gr_report_pell.reporting_pell_cd%TYPE,
560: cp_attending_pell igf_gr_attend_pell.attending_pell_cd%TYPE
561: ) IS
562: SELECT 'Y'
563: FROM igf_gr_report_pell rep,

Line 563: FROM igf_gr_report_pell rep,

559: cp_reporting_pell igf_gr_report_pell.reporting_pell_cd%TYPE,
560: cp_attending_pell igf_gr_attend_pell.attending_pell_cd%TYPE
561: ) IS
562: SELECT 'Y'
563: FROM igf_gr_report_pell rep,
564: igf_gr_attend_pell att
565: WHERE rep.rcampus_id = att.rcampus_id
566: AND rep.ci_cal_type = cp_ci_cal_type
567: AND rep.ci_sequence_number = cp_ci_sequence_number