eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_GEN_002 dependencies on IGF_LOOKUPS_VIEW

Line 30: FUNCTION get_sectionii_stdnt (p_depend_stat IN igf_lookups_view.lookup_code%TYPE,

26: --------------------------------------------------------------------------------------
27: -- sjadhav 03-Mar-2003 Bug 2781382
28: -- removed nvl in get_fed_efc
29: --------------------------------------------------------------------------------------
30: FUNCTION get_sectionii_stdnt (p_depend_stat IN igf_lookups_view.lookup_code%TYPE,
31: p_class_standing IN igf_lookups_view.lookup_code%TYPE,
32: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
33: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
34: p_minvalue IN igf_aw_fi_inc_level.minvalue%TYPE,

Line 31: p_class_standing IN igf_lookups_view.lookup_code%TYPE,

27: -- sjadhav 03-Mar-2003 Bug 2781382
28: -- removed nvl in get_fed_efc
29: --------------------------------------------------------------------------------------
30: FUNCTION get_sectionii_stdnt (p_depend_stat IN igf_lookups_view.lookup_code%TYPE,
31: p_class_standing IN igf_lookups_view.lookup_code%TYPE,
32: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
33: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
34: p_minvalue IN igf_aw_fi_inc_level.minvalue%TYPE,
35: p_maxvalue IN igf_aw_fi_inc_level.maxvalue%TYPE,

Line 72: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

68: --It would retrieve the count of students for the Undergraduate with degree
69: --and Undergraduate without degree.
70:
71: /*CURSOR c_count_ungrad_std (
72: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
73: cp_class_standing igf_lookups_view.lookup_code%TYPE,
74: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
75: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)
76: IS

Line 73: cp_class_standing igf_lookups_view.lookup_code%TYPE,

69: --and Undergraduate without degree.
70:
71: /*CURSOR c_count_ungrad_std (
72: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
73: cp_class_standing igf_lookups_view.lookup_code%TYPE,
74: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
75: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)
76: IS
77: SELECT COUNT (isir.base_id)

Line 104: CURSOR c_count_grad_std ( cp_depend_stat igf_lookups_view.lookup_code%TYPE,

100:
101: --This cursor is for class standing is 3 and AutoZERO EFC is false.
102: --It would retrieve the data for the students whose career level is Graduate.
103:
104: CURSOR c_count_grad_std ( cp_depend_stat igf_lookups_view.lookup_code%TYPE,
105: cp_class_standing igf_lookups_view.lookup_code%TYPE,
106: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
107: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
108: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 105: cp_class_standing igf_lookups_view.lookup_code%TYPE,

101: --This cursor is for class standing is 3 and AutoZERO EFC is false.
102: --It would retrieve the data for the students whose career level is Graduate.
103:
104: CURSOR c_count_grad_std ( cp_depend_stat igf_lookups_view.lookup_code%TYPE,
105: cp_class_standing igf_lookups_view.lookup_code%TYPE,
106: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
107: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
108: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
109: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE,

Line 142: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

138: --It would retrieve the count of students for the Undergraduate with degree
139: --and Undergraduate without degree
140:
141: CURSOR c_count_ungrad_std_efc (
142: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
143: cp_class_standing igf_lookups_view.lookup_code%TYPE,
144: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
145: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
146: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 143: cp_class_standing igf_lookups_view.lookup_code%TYPE,

139: --and Undergraduate without degree
140:
141: CURSOR c_count_ungrad_std_efc (
142: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
143: cp_class_standing igf_lookups_view.lookup_code%TYPE,
144: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
145: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
146: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
147: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE,

Line 180: CURSOR c_count_grad_std_efc ( cp_depend_stat igf_lookups_view.lookup_code%TYPE,

176: WHERE cl.class_standing =cp_class_standing ));
177: --This cursor is for class standing is 3 and AutoZERO EFC is true (Y).
178: --It would retrieve the data for the students whose career level is Graduate.
179:
180: CURSOR c_count_grad_std_efc ( cp_depend_stat igf_lookups_view.lookup_code%TYPE,
181: cp_class_standing igf_lookups_view.lookup_code%TYPE,
182: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
183: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
184: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 181: cp_class_standing igf_lookups_view.lookup_code%TYPE,

177: --This cursor is for class standing is 3 and AutoZERO EFC is true (Y).
178: --It would retrieve the data for the students whose career level is Graduate.
179:
180: CURSOR c_count_grad_std_efc ( cp_depend_stat igf_lookups_view.lookup_code%TYPE,
181: cp_class_standing igf_lookups_view.lookup_code%TYPE,
182: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
183: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
184: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
185: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE,

Line 217: l_class_standing igf_lookups_view.lookup_code%TYPE;

213:
214: */
215:
216: l_std_cnt igf_aw_fisap_ii_h.student_count%TYPE DEFAULT 0;
217: l_class_standing igf_lookups_view.lookup_code%TYPE;
218: l_efc VARCHAR2(10);
219:
220: BEGIN
221: -- code commented as part of Fa132. function only returns 0 since this function is being used

Line 364: p_depend_stat IN igf_lookups_view.lookup_code%TYPE,

360:
361:
362: FUNCTION get_sectionvi_fund ( p_rec_type IN igf_aw_fisap_vi_h.rec_type%TYPE,
363: p_fund_type IN igf_aw_award_v.fed_fund_code%TYPE,
364: p_depend_stat IN igf_lookups_view.lookup_code%TYPE,
365: p_class_standing IN igf_lookups_view.lookup_code%TYPE,
366: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
367: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
368: p_minvalue IN igf_aw_fi_inc_level.minvalue%TYPE,

Line 365: p_class_standing IN igf_lookups_view.lookup_code%TYPE,

361:
362: FUNCTION get_sectionvi_fund ( p_rec_type IN igf_aw_fisap_vi_h.rec_type%TYPE,
363: p_fund_type IN igf_aw_award_v.fed_fund_code%TYPE,
364: p_depend_stat IN igf_lookups_view.lookup_code%TYPE,
365: p_class_standing IN igf_lookups_view.lookup_code%TYPE,
366: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
367: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
368: p_minvalue IN igf_aw_fi_inc_level.minvalue%TYPE,
369: p_maxvalue IN igf_aw_fi_inc_level.maxvalue%TYPE )

Line 394: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

390: /*
391: CURSOR c_non_proff_fund_count (
392: cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
393: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
394: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
395: cp_class_standing igf_lookups_view.lookup_code%TYPE,
396: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
397: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
398: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 395: cp_class_standing igf_lookups_view.lookup_code%TYPE,

391: CURSOR c_non_proff_fund_count (
392: cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
393: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
394: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
395: cp_class_standing igf_lookups_view.lookup_code%TYPE,
396: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
397: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
398: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
399: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )

Line 426: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

422:
423:
424: CURSOR c_proff_fund_count ( cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
425: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
426: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
427: cp_class_standing igf_lookups_view.lookup_code%TYPE,
428: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
429: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
430: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 427: cp_class_standing igf_lookups_view.lookup_code%TYPE,

423:
424: CURSOR c_proff_fund_count ( cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
425: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
426: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
427: cp_class_standing igf_lookups_view.lookup_code%TYPE,
428: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
429: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
430: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
431: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )

Line 458: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

454:
455: CURSOR c_less_ft_fund_count (
456: cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
457: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
458: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
459: cp_class_standing igf_lookups_view.lookup_code%TYPE,
460: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
461: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
462: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 459: cp_class_standing igf_lookups_view.lookup_code%TYPE,

455: CURSOR c_less_ft_fund_count (
456: cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
457: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
458: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
459: cp_class_standing igf_lookups_view.lookup_code%TYPE,
460: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
461: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
462: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
463: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )

Line 490: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

486:
487: CURSOR c_auto_efc_fund_count (
488: cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
489: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
490: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
491: cp_class_standing igf_lookups_view.lookup_code%TYPE,
492: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
493: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
494: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 491: cp_class_standing igf_lookups_view.lookup_code%TYPE,

487: CURSOR c_auto_efc_fund_count (
488: cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
489: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
490: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
491: cp_class_standing igf_lookups_view.lookup_code%TYPE,
492: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
493: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
494: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
495: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )

Line 684: p_depend_stat IN igf_lookups_view.lookup_code%TYPE,

680:
681:
682: FUNCTION get_sectionvi_stdnt (p_rec_type IN igf_aw_fisap_vi_h.rec_type%TYPE,
683: p_fund_type IN igf_aw_award_v.fed_fund_code%TYPE,
684: p_depend_stat IN igf_lookups_view.lookup_code%TYPE,
685: p_class_standing IN igf_lookups_view.lookup_code%TYPE,
686: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
687: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
688: p_minvalue IN igf_aw_fi_inc_level.minvalue%TYPE,

Line 685: p_class_standing IN igf_lookups_view.lookup_code%TYPE,

681:
682: FUNCTION get_sectionvi_stdnt (p_rec_type IN igf_aw_fisap_vi_h.rec_type%TYPE,
683: p_fund_type IN igf_aw_award_v.fed_fund_code%TYPE,
684: p_depend_stat IN igf_lookups_view.lookup_code%TYPE,
685: p_class_standing IN igf_lookups_view.lookup_code%TYPE,
686: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,
687: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
688: p_minvalue IN igf_aw_fi_inc_level.minvalue%TYPE,
689: p_maxvalue IN igf_aw_fi_inc_level.maxvalue%TYPE )

Line 715: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

711: -- and class Standing as 4 ( 4 combination of 1 and 2) and REC_TYPE as "NON_PROFESSIONAL"
712: /*
713: CURSOR c_non_proff_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
714: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
715: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
716: cp_class_standing igf_lookups_view.lookup_code%TYPE,
717: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
718: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
719: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 716: cp_class_standing igf_lookups_view.lookup_code%TYPE,

712: /*
713: CURSOR c_non_proff_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
714: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
715: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
716: cp_class_standing igf_lookups_view.lookup_code%TYPE,
717: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
718: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
719: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
720: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )

Line 752: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

748: -- there is no FSEOG fund for Profession cat.
749:
750: CURSOR c_proff_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
751: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
752: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
753: cp_class_standing igf_lookups_view.lookup_code%TYPE,
754: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
755: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
756: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 753: cp_class_standing igf_lookups_view.lookup_code%TYPE,

749:
750: CURSOR c_proff_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
751: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
752: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
753: cp_class_standing igf_lookups_view.lookup_code%TYPE,
754: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
755: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
756: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
757: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )

Line 787: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

783: --The dependency status passed to this "B", valid fed_fund_code and not 'UNDUPL'
784: --and class standing passed would be GRAD-UGRAD
785: CURSOR c_less_ft_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
786: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
787: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
788: cp_class_standing igf_lookups_view.lookup_code%TYPE,
789: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
790: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
791: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 788: cp_class_standing igf_lookups_view.lookup_code%TYPE,

784: --and class standing passed would be GRAD-UGRAD
785: CURSOR c_less_ft_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
786: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
787: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
788: cp_class_standing igf_lookups_view.lookup_code%TYPE,
789: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
790: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
791: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
792: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )

Line 821: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

817: --FED_FUND_CODE and not 'UNDUPL' and class standing passed would be GRAD-UGRAD
818:
819: CURSOR c_auto_efc_std_count ( cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
820: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
821: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
822: cp_class_standing igf_lookups_view.lookup_code%TYPE,
823: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
824: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
825: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 822: cp_class_standing igf_lookups_view.lookup_code%TYPE,

818:
819: CURSOR c_auto_efc_std_count ( cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
820: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
821: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
822: cp_class_standing igf_lookups_view.lookup_code%TYPE,
823: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
824: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
825: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
826: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )

Line 854: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

850: -- and class Standing as 4 and REC_TYPE as "NON_PROFESSIONAL" and Unduplicate student
851:
852: CURSOR c_non_proff_und_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
853: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
854: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
855: cp_class_standing igf_lookups_view.lookup_code%TYPE,
856: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
857: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
858: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 855: cp_class_standing igf_lookups_view.lookup_code%TYPE,

851:
852: CURSOR c_non_proff_und_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
853: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
854: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
855: cp_class_standing igf_lookups_view.lookup_code%TYPE,
856: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
857: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
858: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
859: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )

Line 891: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

887: -- there is no FSEOG fund for Profession cat.
888:
889: CURSOR c_proff_und_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
890: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
891: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
892: cp_class_standing igf_lookups_view.lookup_code%TYPE,
893: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
894: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
895: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 892: cp_class_standing igf_lookups_view.lookup_code%TYPE,

888:
889: CURSOR c_proff_und_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
890: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
891: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
892: cp_class_standing igf_lookups_view.lookup_code%TYPE,
893: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
894: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
895: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
896: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE ) IS

Line 926: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

922: --and class standing passed would be GRAD-UGRAD
923:
924: CURSOR c_less_ft_und_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
925: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
926: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
927: cp_class_standing igf_lookups_view.lookup_code%TYPE,
928: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
929: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
930: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 927: cp_class_standing igf_lookups_view.lookup_code%TYPE,

923:
924: CURSOR c_less_ft_und_std_count (cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
925: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
926: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
927: cp_class_standing igf_lookups_view.lookup_code%TYPE,
928: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
929: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
930: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
931: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )

Line 961: cp_depend_stat igf_lookups_view.lookup_code%TYPE,

957: --FED_FUND_CODE and 'UNDUPL' and class standing passed would be GRAD-UGRAD
958:
959: CURSOR c_auto_efc_und_std_count ( cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
960: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
961: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
962: cp_class_standing igf_lookups_view.lookup_code%TYPE,
963: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
964: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
965: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

Line 962: cp_class_standing igf_lookups_view.lookup_code%TYPE,

958:
959: CURSOR c_auto_efc_und_std_count ( cp_rec_type igf_aw_fisap_vi_h.rec_type%TYPE,
960: cp_fund_type igf_aw_award_v.fed_fund_code%TYPE,
961: cp_depend_stat igf_lookups_view.lookup_code%TYPE,
962: cp_class_standing igf_lookups_view.lookup_code%TYPE,
963: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
964: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
965: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,
966: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE )

Line 1329: lc_chg_code igf_lookups_view.lookup_code%TYPE;

1325: AND ci_sequence_number = v_seq_num
1326: AND sar_field_number = v_sar_fld ;
1327:
1328:
1329: lc_chg_code igf_lookups_view.lookup_code%TYPE;
1330: l_rowid VARCHAR2(25);
1331: l_isirc_id igf_ap_isir_corr.isirc_id%TYPE;
1332: p_batch_id igf_ap_isir_corr.batch_id%TYPE;
1333: lv_corr_status VARCHAR2(30);