DBA Data[Home] [Help]

APPS.IGS_RU_GEN_001 dependencies on IGS_PS_UNIT_VER_RU

Line 677: FROM IGS_PS_UNIT_VER_RU

673: v_rule_number NUMBER;
674: BEGIN
675: SELECT rul_sequence_number
676: INTO v_rule_number
677: FROM IGS_PS_UNIT_VER_RU
678: WHERE unit_cd = p_unit_cd
679: AND version_number = p_version
680: AND s_rule_call_cd = p_rule_call_name;
681: RETURN v_rule_number;

Line 3378: FROM IGS_PS_UNIT_VER_RU uvr,

3374: SELECT rsm.unit_cd rms_unit_cd,
3375: rsm.versions rms_versions,
3376: uvr.unit_cd uvr_unit_cd,
3377: uvr.version_number uvr_version_number
3378: FROM IGS_PS_UNIT_VER_RU uvr,
3379: igs_ru_item rui,
3380: igs_ru_set_member rsm
3381: WHERE rsm.unit_cd = p_unit_cd
3382: AND uvr.s_rule_call_cd = 'TRANS'