APPS.IGS_RU_VAL_UNIT_RULE dependencies on IGS_PS_UNIT_VER_RU

Line 20: CURSOR cur_uver_rule (cp_unit_cd igs_ps_unit_ver_ru.unit_cd%TYPE,

16: WHERE uoo_id = cp_uoo_id
17: AND s_rule_call_cd = cp_rul_call_cd;
18:
19: --selects the rule number defined for the unit version
20: CURSOR cur_uver_rule (cp_unit_cd igs_ps_unit_ver_ru.unit_cd%TYPE,
21: cp_version_number igs_ps_unit_ver_ru.version_number%TYPE,
22: cp_rul_call_cd igs_ps_unit_ver_ru.s_rule_call_cd%TYPE ) IS
23: SELECT s_rule_call_cd , rul_sequence_number
24: FROM igs_ps_unit_ver_ru

Line 21: cp_version_number igs_ps_unit_ver_ru.version_number%TYPE,

17: AND s_rule_call_cd = cp_rul_call_cd;
18:
19: --selects the rule number defined for the unit version
20: CURSOR cur_uver_rule (cp_unit_cd igs_ps_unit_ver_ru.unit_cd%TYPE,
21: cp_version_number igs_ps_unit_ver_ru.version_number%TYPE,
22: cp_rul_call_cd igs_ps_unit_ver_ru.s_rule_call_cd%TYPE ) IS
23: SELECT s_rule_call_cd , rul_sequence_number
24: FROM igs_ps_unit_ver_ru
25: WHERE unit_cd = cp_unit_cd

Line 22: cp_rul_call_cd igs_ps_unit_ver_ru.s_rule_call_cd%TYPE ) IS

18:
19: --selects the rule number defined for the unit version
20: CURSOR cur_uver_rule (cp_unit_cd igs_ps_unit_ver_ru.unit_cd%TYPE,
21: cp_version_number igs_ps_unit_ver_ru.version_number%TYPE,
22: cp_rul_call_cd igs_ps_unit_ver_ru.s_rule_call_cd%TYPE ) IS
23: SELECT s_rule_call_cd , rul_sequence_number
24: FROM igs_ps_unit_ver_ru
25: WHERE unit_cd = cp_unit_cd
26: AND version_number = cp_version_number

Line 24: FROM igs_ps_unit_ver_ru

20: CURSOR cur_uver_rule (cp_unit_cd igs_ps_unit_ver_ru.unit_cd%TYPE,
21: cp_version_number igs_ps_unit_ver_ru.version_number%TYPE,
22: cp_rul_call_cd igs_ps_unit_ver_ru.s_rule_call_cd%TYPE ) IS
23: SELECT s_rule_call_cd , rul_sequence_number
24: FROM igs_ps_unit_ver_ru
25: WHERE unit_cd = cp_unit_cd
26: AND version_number = cp_version_number
27: AND s_rule_call_cd = cp_rul_call_cd;
28: