APPS.IGF_SL_REL_DISB dependencies on IGF_GR_PELL_SETUP_ALL

Line 651: p_pell_seq_id igf_gr_pell_setup_all.pell_seq_id%TYPE

647: --------------------------------------------------------------------------------------------------------*/
648:
649: -- Get the funding method for pell grant
650: CURSOR cur_get_fund_meth(
651: p_pell_seq_id igf_gr_pell_setup_all.pell_seq_id%TYPE
652: )
653: IS
654: SELECT funding_method
655: FROM igf_gr_pell_setup_all

Line 655: FROM igf_gr_pell_setup_all

651: p_pell_seq_id igf_gr_pell_setup_all.pell_seq_id%TYPE
652: )
653: IS
654: SELECT funding_method
655: FROM igf_gr_pell_setup_all
656: WHERE p_pell_seq_id = pell_seq_id;
657:
658: get_fund_meth_rec cur_get_fund_meth%ROWTYPE;
659:

Line 672: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;

668: FROM igf_aw_awd_disb_all
669: WHERE p_award_id = award_id AND p_disb_num = disb_num;
670:
671: get_disb_date_rec cur_get_disb_date%ROWTYPE;
672: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;
673: l_program_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
674: l_program_version igs_en_stdnt_ps_att_all.version_number%TYPE;
675: l_message fnd_new_messages.message_text%TYPE;
676: l_return_status VARCHAR2(30);