1938: ptype.fin_aid_program_type
1939: FROM igs_ad_acad_history_v acad,
1940: igs_ps_type_all ptype,
1941: igf_ap_fa_base_rec fa,
1942: igs_ps_degrees dc
1943: WHERE fa.base_id = l_base_id
1944: AND acad.person_id = fa.person_id
1945: AND acad.degree_earned = dc.degree_cd
1946: AND dc.program_type = ptype.course_type
3054: ptype.fin_aid_program_type
3055: FROM igs_ad_acad_history_v acad,
3056: igs_ps_type_all ptype,
3057: igf_ap_fa_base_rec fa,
3058: igs_ps_degrees dc
3059: WHERE fa.base_id = l_base_id
3060: AND acad.person_id = fa.person_id
3061: AND acad.degree_earned = dc.degree_cd
3062: AND dc.program_type = ptype.course_type