APPS.IGS_PR_GEN_006 dependencies on IGS_CA_INST

Line 256: v_expiry_dt IGS_CA_INST.end_dt%TYPE;

252: cst_normal CONSTANT VARCHAR2(10) := 'NORMAL';
253: cst_open CONSTANT VARCHAR2(10) := 'OPEN';
254: cst_current CONSTANT VARCHAR2(10) := 'CURRENT';
255: cst_expired CONSTANT VARCHAR2(10) := 'EXPIRED';
256: v_expiry_dt IGS_CA_INST.end_dt%TYPE;
257: v_period_found BOOLEAN DEFAULT FALSE;
258: v_ci_count INTEGER DEFAULT 0;
259: v_dummy VARCHAR2(1);
260: CURSOR c_spo_ci_sca IS

Line 268: IGS_CA_INST ci,

264: spo.duration_type,
265: ci.start_dt,
266: sca.version_number
267: FROM IGS_PR_STDNT_PR_OU spo,
268: IGS_CA_INST ci,
269: IGS_EN_STDNT_PS_ATT sca
270: WHERE spo.person_id = p_person_id AND
271: spo.course_cd = p_course_cd AND
272: spo.sequence_number = p_sequence_number AND

Line 279: cp_prg_start_dt IGS_CA_INST.start_dt%TYPE,

275: sca.person_id = spo.person_id AND
276: sca.course_cd = spo.course_cd;
277: v_spo_rec c_spo_ci_sca%ROWTYPE;
278: CURSOR c_ci_ct_cs (
279: cp_prg_start_dt IGS_CA_INST.start_dt%TYPE,
280: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
281: cp_spo_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,
282: cp_spo_prg_cal_type IGS_PR_STDNT_PR_OU.prg_cal_type%TYPE) IS
283: SELECT ci.cal_type,

Line 285: FROM IGS_CA_INST ci,

281: cp_spo_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,
282: cp_spo_prg_cal_type IGS_PR_STDNT_PR_OU.prg_cal_type%TYPE) IS
283: SELECT ci.cal_type,
284: ci.sequence_number
285: FROM IGS_CA_INST ci,
286: IGS_CA_TYPE ct,
287: IGS_CA_STAT cs
288: WHERE ct.cal_type = ci.cal_type AND
289: ct.s_cal_cat = cst_progress AND

Line 332: IGS_CA_INST_REL cir

328: p_course_cd) = 'Y') AND
329: EXISTS (
330: SELECT 'x'
331: FROM IGS_EN_SU_ATTEMPT sua,
332: IGS_CA_INST_REL cir
333: WHERE sua.person_id = p_person_id AND
334: sua.course_cd = p_coursE_cd AND
335: sua.unit_attempt_status IN ('ENROLLED','COMPLETED','DISCONTIN') AND
336: cir.sup_cal_type = ci.cal_type AND