APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_FI_INVLN_INT

Line 521: l_n_credit_pts igs_fi_invln_int.credit_points%TYPE;

517: Change History
518: Who When What
519: ***************************************************************** */
520: l_v_attendance igs_en_atd_type.attendance_type%TYPE;
521: l_n_credit_pts igs_fi_invln_int.credit_points%TYPE;
522: l_n_fte igs_fi_invln_int.eftsu%TYPE;
523: BEGIN
524: IF p_v_override_excl = 'N' THEN
525: IF g_rec_1098t_setup.excl_non_credit_course_flag = 'Y' THEN

Line 522: l_n_fte igs_fi_invln_int.eftsu%TYPE;

518: Who When What
519: ***************************************************************** */
520: l_v_attendance igs_en_atd_type.attendance_type%TYPE;
521: l_n_credit_pts igs_fi_invln_int.credit_points%TYPE;
522: l_n_fte igs_fi_invln_int.eftsu%TYPE;
523: BEGIN
524: IF p_v_override_excl = 'N' THEN
525: IF g_rec_1098t_setup.excl_non_credit_course_flag = 'Y' THEN
526:

Line 1856: l_n_cp igs_fi_invln_int_all.credit_points%TYPE;

1852: WHERE tax_year_name = cp_v_tax_year_name
1853: AND attendance_type = cp_v_att_type;
1854:
1855: l_v_att_type igs_en_atd_type.attendance_type%TYPE;
1856: l_n_cp igs_fi_invln_int_all.credit_points%TYPE;
1857: l_n_fte igs_fi_invln_int_all.eftsu%TYPE;
1858: l_v_half_time_flag igs_fi_1098t_data.half_time_flag%TYPE;
1859: l_var VARCHAR2(1);
1860: BEGIN

Line 1857: l_n_fte igs_fi_invln_int_all.eftsu%TYPE;

1853: AND attendance_type = cp_v_att_type;
1854:
1855: l_v_att_type igs_en_atd_type.attendance_type%TYPE;
1856: l_n_cp igs_fi_invln_int_all.credit_points%TYPE;
1857: l_n_fte igs_fi_invln_int_all.eftsu%TYPE;
1858: l_v_half_time_flag igs_fi_1098t_data.half_time_flag%TYPE;
1859: l_var VARCHAR2(1);
1860: BEGIN
1861: l_v_half_time_flag := 'N';