APPS.IGS_AS_TRNCMT_LGCY_PUB dependencies on IGS_PS_VER_ALL

Line 379: cp_course_type IGS_PS_VER_ALL.course_type%TYPE

375: ****************************************************************************/
376: IS
377: CURSOR cur_check_course_type(
378: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
379: cp_course_type IGS_PS_VER_ALL.course_type%TYPE
380: )IS
381: SELECT 'X'
382: FROM IGS_EN_STDNT_PS_ATT spa, IGS_PS_VER_ALL pva
383: WHERE spa.course_cd = pva.course_cd

Line 382: FROM IGS_EN_STDNT_PS_ATT spa, IGS_PS_VER_ALL pva

378: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
379: cp_course_type IGS_PS_VER_ALL.course_type%TYPE
380: )IS
381: SELECT 'X'
382: FROM IGS_EN_STDNT_PS_ATT spa, IGS_PS_VER_ALL pva
383: WHERE spa.course_cd = pva.course_cd
384: AND spa.version_number = pva.version_number
385: AND spa.person_id = cp_person_id
386: AND pva.course_type = cp_course_type;

Line 390: cp_course_type igs_ps_ver_all.course_type%TYPE,

386: AND pva.course_type = cp_course_type;
387:
388: CURSOR cur_check_career_term(
389: cp_person_id igs_pe_person.person_id%TYPE,
390: cp_course_type igs_ps_ver_all.course_type%TYPE,
391: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
392: cp_load_ci_sequence_number igs_ca_inst.sequence_number%TYPE
393: ) IS
394: SELECT 'X'