APPS.IGF_GR_PELL dependencies on IGF_GR_RFMS_ALL

Line 377: cp_atd_entity_id igf_gr_rfms_all.atd_entity_id_txt%TYPE) IS

373: l_coa_pell igf_ap_fa_base_rec_all.coa_pell%TYPE;
374:
375: CURSOR c_get_rep_entity_id(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
376: cp_seq_num igs_ca_inst_all.sequence_number%TYPE,
377: cp_atd_entity_id igf_gr_rfms_all.atd_entity_id_txt%TYPE) IS
378: SELECT rep.rep_entity_id_txt
379: FROM igf_gr_attend_pell att,
380: igf_gr_report_pell rep
381: WHERE att.rcampus_id = rep.rcampus_id

Line 394: l_attend_entity_id igf_gr_rfms_all.atd_entity_id_txt%TYPE ;

390: l_ret_status VARCHAR2(1);
391: l_msg_data VARCHAR2(30);
392: l_stu_num VARCHAR2(30);
393: l_cod_year_flag BOOLEAN;
394: l_attend_entity_id igf_gr_rfms_all.atd_entity_id_txt%TYPE ;
395: l_rep_entity_id igf_gr_rfms_all.rep_entity_id_txt%TYPE ;
396:
397:
398:

Line 395: l_rep_entity_id igf_gr_rfms_all.rep_entity_id_txt%TYPE ;

391: l_msg_data VARCHAR2(30);
392: l_stu_num VARCHAR2(30);
393: l_cod_year_flag BOOLEAN;
394: l_attend_entity_id igf_gr_rfms_all.atd_entity_id_txt%TYPE ;
395: l_rep_entity_id igf_gr_rfms_all.rep_entity_id_txt%TYPE ;
396:
397:
398:
399: -- FA 131 - COD Updates Build cursors. 20-NOV-2003 ugummall.

Line 410: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;

406: -- End FA 131.
407:
408: l_return_status VARCHAR2(1);
409: l_return_mesg_text VARCHAR2(2000);
410: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;
411: l_pell_amt igf_gr_rfms.pell_amount%TYPE;
412: l_program_cd igf_gr_pell_setup_all.course_cd%TYPE;
413: l_program_version igf_gr_pell_setup_all.version_number%TYPE;
414: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;