APPS.IGS_EN_OFR_WLST_OPT dependencies on IGS_CA_INST

Line 15: p_cal_type IN igs_ca_inst.cal_type%TYPE,

11: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
12: p_enr_method_type IN igs_en_su_attempt.enr_method_type%TYPE,
13: p_deny_or_warn OUT NOCOPY VARCHAR2,
14: p_message OUT NOCOPY VARCHAR2,
15: p_cal_type IN igs_ca_inst.cal_type%TYPE,
16: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
17: p_audit_requested IN VARCHAR2,
18: p_override_cp IN NUMBER ,
19: p_subtitle IN VARCHAR2 ,

Line 16: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

12: p_enr_method_type IN igs_en_su_attempt.enr_method_type%TYPE,
13: p_deny_or_warn OUT NOCOPY VARCHAR2,
14: p_message OUT NOCOPY VARCHAR2,
15: p_cal_type IN igs_ca_inst.cal_type%TYPE,
16: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
17: p_audit_requested IN VARCHAR2,
18: p_override_cp IN NUMBER ,
19: p_subtitle IN VARCHAR2 ,
20: p_gradsch_cd IN VARCHAR2 ,

Line 65: FROM igs_ps_unit_ofr_opt uoo, igs_ca_inst ci

61: uoo.ss_enrol_ind , uoo.dir_enrollment , uoo.enr_from_wlst ,
62: uoo.inq_not_wlst , uoo.anon_unit_grading_ind , uoo.anon_assess_grading_ind ,
63: uoo.rev_account_cd , uoo.non_std_usec_ind , uoo.auditable_ind ,
64: uoo.audit_permission_ind
65: FROM igs_ps_unit_ofr_opt uoo, igs_ca_inst ci
66: WHERE uoo.cal_type = ci.cal_type
67: AND uoo.ci_sequence_number = ci.sequence_number
68: AND uoo_id = cp_uoo_id ;
69: