APPS.IGS_PR_GEN_001 dependencies on IGS_PR_S_PRG_CAL

Line 55: FROM IGS_PR_S_PRG_CAL spc

51: sopc.prg_cal_type = p_comparison_prg_cal_type AND
52: sopc.stream_num = cp_stream_num;
53: CURSOR c_spc1 IS
54: SELECT spc.stream_num
55: FROM IGS_PR_S_PRG_CAL spc
56: WHERE spc.s_control_num = 1 AND
57: spc.prg_cal_type = p_prg_cal_type;
58: CURSOR c_spc2 (
59: cp_stream_num IGS_PR_S_PRG_CAL.stream_num%TYPE) IS

Line 59: cp_stream_num IGS_PR_S_PRG_CAL.stream_num%TYPE) IS

55: FROM IGS_PR_S_PRG_CAL spc
56: WHERE spc.s_control_num = 1 AND
57: spc.prg_cal_type = p_prg_cal_type;
58: CURSOR c_spc2 (
59: cp_stream_num IGS_PR_S_PRG_CAL.stream_num%TYPE) IS
60: SELECT 'X'
61: FROM IGS_PR_S_PRG_CAL spc
62: WHERE spc.s_control_num = 1 AND
63: spc.prg_cal_type = p_comparison_prg_cal_type AND

Line 61: FROM IGS_PR_S_PRG_CAL spc

57: spc.prg_cal_type = p_prg_cal_type;
58: CURSOR c_spc2 (
59: cp_stream_num IGS_PR_S_PRG_CAL.stream_num%TYPE) IS
60: SELECT 'X'
61: FROM IGS_PR_S_PRG_CAL spc
62: WHERE spc.s_control_num = 1 AND
63: spc.prg_cal_type = p_comparison_prg_cal_type AND
64: spc.stream_num = cp_stream_num;
65: BEGIN