[Home] [Help]
273:
274: CURSOR c_course (cp_nslc_condition VARCHAR2 )IS
275: SELECT DISTINCT spa.course_cd, spa.version_number, hp.party_id org_id, ihp.oss_org_unit_cd org_unit_cd
276: FROM igs_en_stdnt_ps_Att spa , igs_ps_ver vers, hz_parties hp, igs_pe_hz_parties ihp,
277: igs_or_status os
278: WHERE vers.course_cd=spa.course_cd
279: AND vers.version_number=spa.version_number
280: AND spa.cal_type = l_acad_cal_type
281: AND (