APPS.IGS_EN_SPAT_LGCY_PUB dependencies on IGS_PS_VER

Line 296: pc_course_type igs_ps_ver.course_type%TYPE,

292: || Who When What
293: ------------------------------------------------------------------------------*/
294:
295: CURSOR c_igs_en_spa_terms_career(
296: pc_course_type igs_ps_ver.course_type%TYPE,
297: pc_person_id NUMBER,
298: pc_term_cal_type VARCHAR2,
299: pc_term_sequence_number NUMBER,
300: pc_program_cd igs_en_spa_terms.program_cd%TYPE) IS

Line 302: FROM igs_en_spa_terms spa_terms, igs_ps_ver ps_ver

298: pc_term_cal_type VARCHAR2,
299: pc_term_sequence_number NUMBER,
300: pc_program_cd igs_en_spa_terms.program_cd%TYPE) IS
301: SELECT 'X'
302: FROM igs_en_spa_terms spa_terms, igs_ps_ver ps_ver
303: WHERE
304: spa_terms.person_id = pc_person_id AND
305: spa_terms.term_cal_type = pc_term_cal_type AND
306: spa_terms.term_sequence_number = pc_term_sequence_number AND

Line 327: cp_program_cd igs_ps_ver.course_cd%TYPE,

323: program_cd <> pc_program_cd AND
324: key_program_flag = 'Y';
325:
326: CURSOR c_course_type_p_spat_rec(
327: cp_program_cd igs_ps_ver.course_cd%TYPE,
328: cp_program_version igs_ps_ver.version_number%TYPE) IS
329: SELECT course_type
330: FROM igs_ps_ver
331: WHERE

Line 328: cp_program_version igs_ps_ver.version_number%TYPE) IS

324: key_program_flag = 'Y';
325:
326: CURSOR c_course_type_p_spat_rec(
327: cp_program_cd igs_ps_ver.course_cd%TYPE,
328: cp_program_version igs_ps_ver.version_number%TYPE) IS
329: SELECT course_type
330: FROM igs_ps_ver
331: WHERE
332: course_cd = cp_program_cd AND

Line 330: FROM igs_ps_ver

326: CURSOR c_course_type_p_spat_rec(
327: cp_program_cd igs_ps_ver.course_cd%TYPE,
328: cp_program_version igs_ps_ver.version_number%TYPE) IS
329: SELECT course_type
330: FROM igs_ps_ver
331: WHERE
332: course_cd = cp_program_cd AND
333: version_number = cp_program_version;
334:

Line 338: l_course_type_p_spat_rec igs_ps_ver.course_type%TYPE;

334:
335: l_return_value BOOLEAN := TRUE;
336: l_igs_en_spa_terms_career c_igs_en_spa_terms_career%ROWTYPE;
337: l_igs_en_spa_terms_normal c_igs_en_spa_terms_normal%ROWTYPE;
338: l_course_type_p_spat_rec igs_ps_ver.course_type%TYPE;
339: l_career_flag VARCHAR2(1);
340:
341: BEGIN
342: OPEN c_course_type_p_spat_rec(p_spat_rec.program_cd, p_spat_rec.program_version);