APPS.IGF_AP_GEN_001 dependencies on IGS_EN_SPA_TERMS

Line 94: cp_term_enr_dtl_rec igs_en_spa_terms%ROWTYPE;

90: l_adm_appl adm_appl_cur%ROWTYPE;
91: l_person_id VARCHAR2(20);
92: lv_course_start_dt DATE;
93: l_completion_dt DATE;
94: cp_term_enr_dtl_rec igs_en_spa_terms%ROWTYPE;
95: x_course_cd igs_ps_ver_all.course_cd%TYPE;
96: x_version_number igs_ps_ver_all.version_number%TYPE;
97:
98: CURSOR c_spa( cp_person_id hz_parties.party_id%TYPE,

Line 256: cp_term_enr_dtl_rec igs_en_spa_terms%ROWTYPE;

252: || sjalasut Dec 03, 2003 removed the cursor key_program_cur
253: || and replaced with the get_term_enrlmnt_dtl to get the
254: || key program
255: */
256: cp_term_enr_dtl_rec igs_en_spa_terms%ROWTYPE;
257: BEGIN
258: -- call get_term_enrlmnt_dtl so that based on the base_id it calculates the term and
259: -- gets the key program from that term (if any) otherwise returns the key program from the spa
260: get_term_enrlmnt_dtl(cp_base_id,cp_term_enr_dtl_rec);

Line 270: cp_term_enr_dtl_rec OUT NOCOPY IGS_EN_SPA_TERMS%ROWTYPE) IS

266: END get_key_program;
267:
268: --Procedure to get the applicable enrollment term details.
269: PROCEDURE get_term_enrlmnt_dtl(cp_fa_base_id IN IGF_AP_FA_BASE_REC_ALL.BASE_ID%TYPE,
270: cp_term_enr_dtl_rec OUT NOCOPY IGS_EN_SPA_TERMS%ROWTYPE) IS
271: /*
272: || Created By : sjalasut
273: || Created On : 03 Dec 2003
274: || Purpose : Function to get applicable enrollment details

Line 348: FROM IGS_EN_SPA_TERMS spa,

344: ORDER BY enrolled_start_dt;
345:
346: CURSOR c_spa_terms( cp_person_id hz_parties.party_id%TYPE, cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_no igs_ca_inst.sequence_number%TYPE)IS
347: SELECT spa.*
348: FROM IGS_EN_SPA_TERMS spa,
349: (SELECT su.person_id,
350: su.course_cd,
351: su.version_number,
352: tl.load_cal_type,

Line 531: FROM igs_en_spa_terms

527: cp_cal_type igs_ca_inst.cal_type%TYPE,
528: cp_seq_no igs_ca_inst.sequence_number%TYPE
529: ) IS
530: SELECT *
531: FROM igs_en_spa_terms
532: WHERE person_id = cp_person_id
533: AND term_cal_type = cp_cal_type
534: AND term_sequence_number = cp_seq_no
535: AND key_program_flag = 'Y';