APPS.IGS_PR_GEN_001 dependencies on IGS_PR_S_OU_PRG_CAL

Line 35: FROM IGS_PR_S_OU_PRG_CAL sopc

31: CURSOR c_sopc1 IS
32: SELECT sopc.org_unit_cd,
33: sopc.ou_start_dt,
34: sopc.stream_num
35: FROM IGS_PR_S_OU_PRG_CAL sopc
36: WHERE prgp_get_crv_cmt(
37: p_course_cd,
38: p_version_number,
39: sopc.org_unit_cd,

Line 44: cp_org_unit_cd IGS_PR_S_OU_PRG_CAL.org_unit_cd%TYPE,

40: sopc.ou_start_dt) = 'Y' AND
41: sopc.prg_cal_type = p_prg_cal_type;
42: v_sopc_rec c_sopc1%ROWTYPE;
43: CURSOR c_sopc2 (
44: cp_org_unit_cd IGS_PR_S_OU_PRG_CAL.org_unit_cd%TYPE,
45: cp_ou_start_dt IGS_PR_S_OU_PRG_CAL.ou_start_dt%TYPE,
46: cp_stream_num IGS_PR_S_OU_PRG_CAL.stream_num%TYPE) IS
47: SELECT 'X'
48: FROM IGS_PR_S_OU_PRG_CAL sopc

Line 45: cp_ou_start_dt IGS_PR_S_OU_PRG_CAL.ou_start_dt%TYPE,

41: sopc.prg_cal_type = p_prg_cal_type;
42: v_sopc_rec c_sopc1%ROWTYPE;
43: CURSOR c_sopc2 (
44: cp_org_unit_cd IGS_PR_S_OU_PRG_CAL.org_unit_cd%TYPE,
45: cp_ou_start_dt IGS_PR_S_OU_PRG_CAL.ou_start_dt%TYPE,
46: cp_stream_num IGS_PR_S_OU_PRG_CAL.stream_num%TYPE) IS
47: SELECT 'X'
48: FROM IGS_PR_S_OU_PRG_CAL sopc
49: WHERE sopc.org_unit_cd = cp_org_unit_cd AND

Line 46: cp_stream_num IGS_PR_S_OU_PRG_CAL.stream_num%TYPE) IS

42: v_sopc_rec c_sopc1%ROWTYPE;
43: CURSOR c_sopc2 (
44: cp_org_unit_cd IGS_PR_S_OU_PRG_CAL.org_unit_cd%TYPE,
45: cp_ou_start_dt IGS_PR_S_OU_PRG_CAL.ou_start_dt%TYPE,
46: cp_stream_num IGS_PR_S_OU_PRG_CAL.stream_num%TYPE) IS
47: SELECT 'X'
48: FROM IGS_PR_S_OU_PRG_CAL sopc
49: WHERE sopc.org_unit_cd = cp_org_unit_cd AND
50: sopc.ou_start_dt = cp_ou_start_dt AND

Line 48: FROM IGS_PR_S_OU_PRG_CAL sopc

44: cp_org_unit_cd IGS_PR_S_OU_PRG_CAL.org_unit_cd%TYPE,
45: cp_ou_start_dt IGS_PR_S_OU_PRG_CAL.ou_start_dt%TYPE,
46: cp_stream_num IGS_PR_S_OU_PRG_CAL.stream_num%TYPE) IS
47: SELECT 'X'
48: FROM IGS_PR_S_OU_PRG_CAL sopc
49: WHERE sopc.org_unit_cd = cp_org_unit_cd AND
50: sopc.ou_start_dt = cp_ou_start_dt AND
51: sopc.prg_cal_type = p_comparison_prg_cal_type AND
52: sopc.stream_num = cp_stream_num;