DBA Data[Home] [Help]

APPS.IGS_RU_GEN_001 dependencies on IGS_PS_STAGE_RU

Line 777: FROM IGS_PS_STAGE_RU

773: v_rule_number NUMBER;
774: BEGIN
775: SELECT rul_sequence_number
776: INTO v_rule_number
777: FROM IGS_PS_STAGE_RU
778: WHERE course_cd = p_course_cd
779: AND version_number = p_course_version
780: AND cst_sequence_number = p_cst_sequence_number
781: AND s_rule_call_cd = p_rule_call_name;

Line 3210: FROM igs_ps_stage_ru

3206: lc_version_number igs_ps_stage.version_number%TYPE,
3207: lc_cst_sequence_number igs_ps_stage.sequence_number%TYPE,
3208: lc_course_stage_type igs_ps_stage.course_stage_type%TYPE) IS
3209: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)
3210: FROM igs_ps_stage_ru
3211: WHERE course_cd = lc_course_cd
3212: AND version_number = lc_version_number
3213: AND cst_sequence_number = lc_cst_sequence_number
3214: AND s_rule_call_cd = lc_course_stage_type;