APPS.IGF_GR_RFMS_ORIG dependencies on IGF_GR_ATTEND_PELL

Line 659: cp_attending_pell igf_gr_attend_pell.attending_pell_cd%TYPE)

655: -- Cursor to check attending pell id is a child of reporting pell id
656: CURSOR cur_attending_pell(cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,
657: cp_ci_sequence_number igf_gr_report_pell.ci_sequence_number%TYPE,
658: cp_reporting_pell igf_gr_report_pell.reporting_pell_cd%TYPE,
659: cp_attending_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
660: IS
661: SELECT 'Y'
662: FROM igf_gr_report_pell rep,
663: igf_gr_attend_pell att

Line 663: igf_gr_attend_pell att

659: cp_attending_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
660: IS
661: SELECT 'Y'
662: FROM igf_gr_report_pell rep,
663: igf_gr_attend_pell att
664: WHERE rep.rcampus_id = att.rcampus_id
665: AND rep.ci_cal_type = cp_ci_cal_type
666: AND rep.ci_sequence_number = cp_ci_sequence_number
667: AND rep.reporting_pell_cd = cp_reporting_pell

Line 823: FND_MESSAGE.SET_NAME('IGF','IGF_GR_ATTEND_PELL_NOT_SETUP');

819: IF (cur_attending_pell%NOTFOUND) THEN -- Attending pell child records exists?
820:
821: -- No attending pell child record exists. Skip this record
822: CLOSE cur_attending_pell;
823: FND_MESSAGE.SET_NAME('IGF','IGF_GR_ATTEND_PELL_NOT_SETUP');
824: FND_MESSAGE.SET_TOKEN('ATT_PELL','');
825: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
826: ELSE
827: -- attending pell child record exists. Proceed further...