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 IGS_CA_INST

Line 32: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,

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,
36: p_efc IN VARCHAR2)

Line 33: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

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,
36: p_efc IN VARCHAR2)
37: RETURN NUMBER

Line 74: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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)
78: FROM igf_ap_isir_matched isir,

Line 75: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE)

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)
78: FROM igf_ap_isir_matched isir,
79: igf_ap_fa_base_rec fa

Line 106: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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,
110: cp_efc VARCHAR2 )

Line 107: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

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,
110: cp_efc VARCHAR2 )
111: IS

Line 144: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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,
148: cp_efc VARCHAR2)

Line 145: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

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,
148: cp_efc VARCHAR2)
149: IS

Line 182: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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,
186: cp_efc VARCHAR2)

Line 183: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

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,
186: cp_efc VARCHAR2)
187: IS

Line 366: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,

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 )
370: RETURN NUMBER

Line 367: p_ci_sequence_number IN igs_ca_inst.sequence_number%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 )
370: RETURN NUMBER
371: IS

Line 396: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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 )
400: IS

Line 397: cp_ci_sequence_number igs_ca_inst.sequence_number%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 )
400: IS
401: SELECT NVL(SUM(awd.paid_amt),0)

Line 428: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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 )
432: IS

Line 429: cp_ci_sequence_number igs_ca_inst.sequence_number%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 )
432: IS
433: SELECT NVL(SUM(awd.paid_amt),0)

Line 460: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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 )
464: IS

Line 461: cp_ci_sequence_number igs_ca_inst.sequence_number%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 )
464: IS
465: SELECT NVL(SUM(awd.paid_amt),0)

Line 492: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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 )
496: IS

Line 493: cp_ci_sequence_number igs_ca_inst.sequence_number%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 )
496: IS
497: SELECT NVL(SUM(awd.paid_amt),0)

Line 686: p_ci_cal_type IN igs_ca_inst.cal_type%TYPE,

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 )
690: RETURN NUMBER

Line 687: p_ci_sequence_number IN igs_ca_inst.sequence_number%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 )
690: RETURN NUMBER
691: IS

Line 717: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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 )
721: IS

Line 718: cp_ci_sequence_number igs_ca_inst.sequence_number%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 )
721: IS
722: SELECT COUNT (isir.base_id )

Line 754: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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 )
758: IS

Line 755: cp_ci_sequence_number igs_ca_inst.sequence_number%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 )
758: IS
759: SELECT COUNT (isir.base_id )

Line 789: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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 )
793: IS

Line 790: cp_ci_sequence_number igs_ca_inst.sequence_number%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 )
793: IS
794: SELECT COUNT (isir.base_id )

Line 823: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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 )
827: IS

Line 824: cp_ci_sequence_number igs_ca_inst.sequence_number%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 )
827: IS
828: SELECT COUNT ( isir.base_id )

Line 856: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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 )
860: IS

Line 857: cp_ci_sequence_number igs_ca_inst.sequence_number%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 )
860: IS
861: SELECT COUNT ( DISTINCT (isir.base_id ) )

Line 893: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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
897: SELECT COUNT (DISTINCT (isir.base_id ) )

Line 894: cp_ci_sequence_number igs_ca_inst.sequence_number%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
897: SELECT COUNT (DISTINCT (isir.base_id ) )
898: FROM igf_ap_isir_matched isir,

Line 928: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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 )
932: IS

Line 929: cp_ci_sequence_number igs_ca_inst.sequence_number%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 )
932: IS
933: SELECT COUNT (DISTINCT(isir.base_id ))

Line 963: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,

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 )
967: IS

Line 964: cp_ci_sequence_number igs_ca_inst.sequence_number%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 )
967: IS
968: SELECT COUNT (DISTINCT(isir.base_id ))