APPS.IGS_PR_GEN_003 dependencies on IGS_PR_S_CRV_PRG_CAL

Line 33: FROM IGS_PR_S_CRV_PRG_CAL scpca

29: CURSOR c_scpca IS
30: SELECT scpca.stream_num,
31: scpca.show_cause_length,
32: scpca.appeal_length
33: FROM IGS_PR_S_CRV_PRG_CAL scpca
34: WHERE scpca.course_cd = p_course_cd AND
35: scpca.version_number = p_version_number AND
36: scpca.prg_cal_type = p_prg_cal_type;
37: CURSOR c_sopca (

Line 168: FROM IGS_PR_S_CRV_PRG_CAL scpca

164: WHERE scpc.course_cd = p_course_cd AND
165: scpc.version_number = p_version_number;
166: CURSOR c_scpca IS
167: SELECT 'X'
168: FROM IGS_PR_S_CRV_PRG_CAL scpca
169: WHERE scpca.course_cd = p_course_cd AND
170: scpca.version_number = p_version_number;
171: CURSOR c_sopc IS
172: SELECT sopc.org_unit_cd,