DBA Data[Home] [Help]

APPS.IGF_GR_PELL_CALC dependencies on IGS_EN_PSV_TERM_IT

Line 54: p_course_cd igs_en_psv_term_it.course_cd%TYPE,

50: NO_SETUP EXCEPTION;
51:
52: PROCEDURE get_pm_3_acad_term_wks(p_cal_type igs_ca_inst_all.cal_type%TYPE,
53: p_seq_number igs_ca_inst_all.sequence_number%TYPE,
54: p_course_cd igs_en_psv_term_it.course_cd%TYPE,
55: p_version_number igs_en_psv_term_it.version_number%TYPE,
56: p_term_weeks OUT NOCOPY NUMBER,
57: p_acad_weeks OUT NOCOPY NUMBER,
58: p_result OUT NOCOPY VARCHAR2,

Line 55: p_version_number igs_en_psv_term_it.version_number%TYPE,

51:
52: PROCEDURE get_pm_3_acad_term_wks(p_cal_type igs_ca_inst_all.cal_type%TYPE,
53: p_seq_number igs_ca_inst_all.sequence_number%TYPE,
54: p_course_cd igs_en_psv_term_it.course_cd%TYPE,
55: p_version_number igs_en_psv_term_it.version_number%TYPE,
56: p_term_weeks OUT NOCOPY NUMBER,
57: p_acad_weeks OUT NOCOPY NUMBER,
58: p_result OUT NOCOPY VARCHAR2,
59: p_message OUT NOCOPY VARCHAR2)

Line 75: FROM igs_en_psv_term_it

71:
72: CURSOR cur_get_term_instr_time
73: IS
74: SELECT term_instruction_time
75: FROM igs_en_psv_term_it
76: WHERE cal_type = p_cal_type
77: AND sequence_number = p_seq_number
78: AND course_cd = p_course_cd
79: AND version_number = p_version_number;