APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_EN_SPA_AWD_AIM

Line 97: FUNCTION validate_award_conferral_dates (p_std_awd_cmp_ind IN igs_en_spa_awd_aim.complete_ind%TYPE,

93:
94: -- created by jtmathew
95: -- used to filter out students whose awards are not conferred
96: -- between the correct award conferral dates.
97: FUNCTION validate_award_conferral_dates (p_std_awd_cmp_ind IN igs_en_spa_awd_aim.complete_ind%TYPE,
98: p_std_awd_conf_dt IN igs_en_spa_awd_aim.conferral_date%TYPE,
99: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
100: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)
101: RETURN BOOLEAN

Line 98: p_std_awd_conf_dt IN igs_en_spa_awd_aim.conferral_date%TYPE,

94: -- created by jtmathew
95: -- used to filter out students whose awards are not conferred
96: -- between the correct award conferral dates.
97: FUNCTION validate_award_conferral_dates (p_std_awd_cmp_ind IN igs_en_spa_awd_aim.complete_ind%TYPE,
98: p_std_awd_conf_dt IN igs_en_spa_awd_aim.conferral_date%TYPE,
99: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
100: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)
101: RETURN BOOLEAN
102: IS

Line 1075: igs_en_spa_awd_aim enawd,

1071: enawd.conferral_date
1072: FROM igs_en_stdnt_ps_att_all sca,
1073: igs_he_st_spa_all hspa,
1074: igs_he_st_prog_all hprog,
1075: igs_en_spa_awd_aim enawd,
1076: hz_parties pe
1077: WHERE sca.person_id = hspa.person_id
1078: AND sca.course_cd = hspa.course_cd
1079: AND sca.course_cd = hprog.course_cd (+)

Line 1137: igs_en_spa_awd_aim enawd,

1133: FROM igs_as_su_setatmpt susa,
1134: igs_he_en_susa husa,
1135: igs_en_unit_set us,
1136: igs_en_unit_set_cat susc,
1137: igs_en_spa_awd_aim enawd,
1138: igs_en_stdnt_ps_att_all sca
1139: WHERE susa.person_id = sca.person_id
1140: AND susa.course_cd = sca.course_cd
1141: AND sca.person_id = enawd.person_id(+)