APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_VER_ALL

Line 1264: IGS_PS_VER_ALL pv

1260: pv.course_cd,
1261: pv.version_number,
1262: pv.title
1263: FROM IGS_EN_STDNT_PS_ATT_ALL sca,
1264: IGS_PS_VER_ALL pv
1265: WHERE pv.course_cd = sca.course_cd
1266: AND pv.version_number = igs_en_spa_terms_api.get_spat_program_version(sca.person_id, sca.course_cd, p_term_cal_type,
1267: p_term_sequence_number)
1268: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')

Line 1279: IGS_PS_VER_ALL pv

1275:
1276: CURSOR get_secondary_prgm_dtls (p_course_code igs_en_stdnt_ps_att.course_cd%TYPE)IS
1277: SELECT pv.title
1278: FROM IGS_EN_STDNT_PS_ATT_ALL sca,
1279: IGS_PS_VER_ALL pv
1280: WHERE pv.course_cd = sca.course_cd
1281: AND pv.version_number = sca.version_number
1282: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
1283: AND sca.person_id = p_person_id

Line 2481: igs_ps_ver_all pv

2477: -- get the program title
2478: CURSOR c_prg_title (cp_person_id NUMBER,cp_program_cd VARCHAR2,cp_term_cal VARCHAR2,cp_term_seq_num NUMBER) IS
2479: SELECT pv.title
2480: FROM igs_en_stdnt_ps_att_all sca,
2481: igs_ps_ver_all pv
2482: WHERE pv.course_cd = sca.course_cd
2483: AND pv.version_number = sca.version_number
2484: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
2485: AND sca.person_id = cp_person_id

Line 2491: l_prg_title igs_ps_ver_all.title%TYPE;

2487: AND ((igs_en_spa_terms_api.get_spat_primary_prg(cp_person_id,cp_program_cd,cp_term_cal,cp_term_seq_num) = 'PRIMARY') OR
2488: (NVL(fnd_profile.value('CAREER_MODEL_ENABLED'),'N')= 'N')
2489: );
2490:
2491: l_prg_title igs_ps_ver_all.title%TYPE;
2492:
2493: BEGIN
2494:
2495: OPEN c_prg_title(p_person_id,p_program_cd,p_term_cal_type,p_term_sequence_number);

Line 2528: igs_ps_ver_all pv

2524: CURSOR c_sec_prg_title (cp_person_id NUMBER,cp_program_cd VARCHAR2,cp_version_number NUMBER,
2525: cp_term_cal VARCHAR2,cp_term_seq_num NUMBER) IS
2526: SELECT pv.title
2527: FROM igs_en_stdnt_ps_att_all sca,
2528: igs_ps_ver_all pv
2529: WHERE pv.course_cd = sca.course_cd
2530: AND pv.version_number = sca.version_number
2531: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
2532: AND sca.person_id = cp_person_id

Line 2535: FROM igs_ps_ver_all

2531: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')
2532: AND sca.person_id = cp_person_id
2533: AND igs_en_spa_terms_api.get_spat_primary_prg(cp_person_id,cp_program_cd,cp_term_cal,cp_term_seq_num) <> 'PRIMARY'
2534: AND pv.course_type = (SELECT course_type
2535: FROM igs_ps_ver_all
2536: WHERE course_cd = cp_program_cd
2537: AND version_number = cp_version_number);
2538:
2539: l_sec_prg_title VARCHAR2(2000);