APPS.IGS_PR_GEN_001 dependencies on IGS_PR_S_CRV_PRG_CAL

Line 15: v_stream_num IGS_PR_S_CRV_PRG_CAL.stream_num%TYPE;

11: -- Get whether a progression calendar instance is within the same stream as
12: -- another. This refers to the stream concepts held within the progression
13: -- configuration structure.
14: DECLARE
15: v_stream_num IGS_PR_S_CRV_PRG_CAL.stream_num%TYPE;
16: v_dummy VARCHAR2(1);
17: CURSOR c_scpc1 IS
18: SELECT scpc.stream_num
19: FROM IGS_PR_S_CRV_PRG_CAL scpc

Line 19: FROM IGS_PR_S_CRV_PRG_CAL scpc

15: v_stream_num IGS_PR_S_CRV_PRG_CAL.stream_num%TYPE;
16: v_dummy VARCHAR2(1);
17: CURSOR c_scpc1 IS
18: SELECT scpc.stream_num
19: FROM IGS_PR_S_CRV_PRG_CAL scpc
20: WHERE scpc.course_cd = p_course_cd AND
21: scpc.version_number = p_version_number AND
22: scpc.prg_cal_type = p_prg_cal_type;
23: CURSOR c_scpc2 (

Line 24: cp_stream_num IGS_PR_S_CRV_PRG_CAL.stream_num%TYPE) IS

20: WHERE scpc.course_cd = p_course_cd AND
21: scpc.version_number = p_version_number AND
22: scpc.prg_cal_type = p_prg_cal_type;
23: CURSOR c_scpc2 (
24: cp_stream_num IGS_PR_S_CRV_PRG_CAL.stream_num%TYPE) IS
25: SELECT 'X'
26: FROM IGS_PR_S_CRV_PRG_CAL scpc
27: WHERE scpc.course_cd = p_course_cd AND
28: scpc.version_number = p_version_number AND

Line 26: FROM IGS_PR_S_CRV_PRG_CAL scpc

22: scpc.prg_cal_type = p_prg_cal_type;
23: CURSOR c_scpc2 (
24: cp_stream_num IGS_PR_S_CRV_PRG_CAL.stream_num%TYPE) IS
25: SELECT 'X'
26: FROM IGS_PR_S_CRV_PRG_CAL scpc
27: WHERE scpc.course_cd = p_course_cd AND
28: scpc.version_number = p_version_number AND
29: scpc.prg_cal_type = p_comparison_prg_cal_type AND
30: scpc.stream_num = cp_stream_num;