DBA Data[Home] [Help]

APPS.IGS_PR_GEN_005 dependencies on IGS_RU_GEN_003

Line 191: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)

187: v_ssp_sequence_number igs_pr_s_scratch_pad.sequence_number%TYPE;
188: v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE;
189: v_version_number igs_en_stdnt_ps_att.version_number%TYPE;
190: CURSOR c_cvr IS
191: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)
192: FROM igs_ps_ver_ru
193: WHERE course_cd = v_course_cd
194: AND version_number = v_version_number
195: AND s_rule_call_cd = p_s_rule_call_cd;

Line 197: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)

193: WHERE course_cd = v_course_cd
194: AND version_number = v_version_number
195: AND s_rule_call_cd = p_s_rule_call_cd;
196: CURSOR c_csr IS
197: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)
198: FROM igs_ps_stage_ru
199: WHERE course_cd = v_course_cd
200: AND version_number = v_version_number
201: AND cst_sequence_number = p_cst_sequence_number

Line 204: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)

200: AND version_number = v_version_number
201: AND cst_sequence_number = p_cst_sequence_number
202: AND s_rule_call_cd = p_s_rule_call_cd;
203: CURSOR c_usr IS
204: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)
205: FROM igs_en_unit_set_rule
206: WHERE unit_set_cd = p_unit_set_cd
207: AND version_number = p_us_version_number
208: AND s_rule_call_cd = p_s_rule_call_cd;