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.

[Home] [Help]

APPS.IGF_AW_GEN_002 dependencies on IGF_AW_FI_INC_LEVEL

Line 34: p_minvalue IN igf_aw_fi_inc_level.minvalue%TYPE,

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
38: IS

Line 35: p_maxvalue IN igf_aw_fi_inc_level.maxvalue%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
38: IS
39:

Line 108: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

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

Line 109: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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
112: SELECT COUNT (isir.base_id)
113: FROM igf_ap_isir_matched isir,

Line 146: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

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

Line 147: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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
150: SELECT COUNT (isir.base_id)
151: FROM igf_ap_isir_matched isir,

Line 184: cp_minvalue igf_aw_fi_inc_level.minvalue%TYPE,

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

Line 185: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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
188: SELECT COUNT (isir.base_id)
189: FROM igf_ap_isir_matched isir,

Line 368: p_minvalue IN igf_aw_fi_inc_level.minvalue%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
372:

Line 369: p_maxvalue IN igf_aw_fi_inc_level.maxvalue%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
372:
373: ------------------------------------------------------------------------------------

Line 398: cp_minvalue igf_aw_fi_inc_level.minvalue%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)
402: FROM igf_ap_isir_matched isir,

Line 399: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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)
402: FROM igf_ap_isir_matched isir,
403: igf_aw_award_v awd,

Line 430: cp_minvalue igf_aw_fi_inc_level.minvalue%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)
434: FROM igf_ap_isir_matched isir,

Line 431: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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)
434: FROM igf_ap_isir_matched isir,
435: igf_aw_award_v awd,

Line 462: cp_minvalue igf_aw_fi_inc_level.minvalue%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)
466: FROM igf_ap_isir_matched isir,

Line 463: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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)
466: FROM igf_ap_isir_matched isir,
467: igf_aw_award_v awd,

Line 494: cp_minvalue igf_aw_fi_inc_level.minvalue%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)
498: FROM igf_ap_isir_matched isir,

Line 495: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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)
498: FROM igf_ap_isir_matched isir,
499: igf_aw_award_v awd,

Line 688: p_minvalue IN igf_aw_fi_inc_level.minvalue%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
692:

Line 689: p_maxvalue IN igf_aw_fi_inc_level.maxvalue%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
692:
693: ------------------------------------------------------------------------------------

Line 719: cp_minvalue igf_aw_fi_inc_level.minvalue%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 )
723: FROM igf_ap_isir_matched isir,

Line 720: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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 )
723: FROM igf_ap_isir_matched isir,
724: igf_aw_award_v awd,

Line 756: cp_minvalue igf_aw_fi_inc_level.minvalue%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 )
760: FROM igf_ap_isir_matched isir,

Line 757: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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 )
760: FROM igf_ap_isir_matched isir,
761: igf_aw_award_v awd,

Line 791: cp_minvalue igf_aw_fi_inc_level.minvalue%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 )
795: FROM igf_ap_isir_matched isir,

Line 792: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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 )
795: FROM igf_ap_isir_matched isir,
796: igf_aw_award_v awd,

Line 825: cp_minvalue igf_aw_fi_inc_level.minvalue%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 )
829: FROM igf_ap_isir_matched isir,

Line 826: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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 )
829: FROM igf_ap_isir_matched isir,
830: igf_aw_award_v awd,

Line 858: cp_minvalue igf_aw_fi_inc_level.minvalue%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 ) )
862: FROM igf_ap_isir_matched isir,

Line 859: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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 ) )
862: FROM igf_ap_isir_matched isir,
863: igf_aw_award_v awd,

Line 895: cp_minvalue igf_aw_fi_inc_level.minvalue%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,
899: igf_aw_award_v awd,

Line 896: cp_maxvalue igf_aw_fi_inc_level.maxvalue%TYPE ) IS

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,
899: igf_aw_award_v awd,
900: igf_ap_fa_base_rec fa

Line 930: cp_minvalue igf_aw_fi_inc_level.minvalue%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 ))
934: FROM igf_ap_isir_matched isir,

Line 931: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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 ))
934: FROM igf_ap_isir_matched isir,
935: igf_aw_award_v awd,

Line 965: cp_minvalue igf_aw_fi_inc_level.minvalue%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 ))
969: FROM igf_ap_isir_matched isir,

Line 966: cp_maxvalue igf_aw_fi_inc_level.maxvalue%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 ))
969: FROM igf_ap_isir_matched isir,
970: igf_aw_award_v awd,