DBA Data[Home] [Help]

APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_UNIT_VER_RU

Line 3444: FROM igs_ps_unit_ver_ru ru,

3440:
3441: --cursor to look up the rule code in unit version rules
3442: CURSOR c_unit_ru(cp_n_uoo_id IN NUMBER, cp_c_rul_call_cd IN VARCHAR2) IS
3443: SELECT ru.rul_sequence_number
3444: FROM igs_ps_unit_ver_ru ru,
3445: igs_ps_unit_ofr_opt_all uoo
3446: WHERE uoo.uoo_id = p_n_uoo_id
3447: AND uoo.unit_cd = ru.unit_cd
3448: AND uoo.version_number = ru.version_number

Line 3598: FROM igs_ps_unit_ver_ru uvr,

3594:
3595: --Check if the prereq/coreq rule is setup at the unit version level.
3596: CURSOR c_get_unit_rul_seq_no IS
3597: SELECT rul_sequence_number
3598: FROM igs_ps_unit_ver_ru uvr,
3599: igs_ps_unit_ofr_opt uoo
3600: WHERE uvr.unit_cd = uoo.unit_cd
3601: AND uvr.version_number = uoo.version_number
3602: AND uoo_id = p_uoo_id

Line 4950: FROM igs_ps_unit_ver_ru uvr, igs_ps_unit_ofr_opt uoo

4946:
4947: /*** get the coreq rule defined at the unit version rules ***/
4948: Cursor c_coreq_unit(cp_uoo_id NUMBER) IS
4949: SELECT rul_sequence_number
4950: FROM igs_ps_unit_ver_ru uvr, igs_ps_unit_ofr_opt uoo
4951: WHERE uvr.unit_cd = uoo.unit_cd
4952: AND uvr.version_number = uoo.version_number
4953: AND uoo_id = cp_uoo_id
4954: AND uvr.s_rule_call_cd = 'COREQ';