APPS.IGS_RU_GEN_001 dependencies on IGS_EN_UNIT_SET

Line 721: FROM IGS_EN_UNIT_SET_RULE

717: v_rule_number NUMBER;
718: BEGIN
719: SELECT rul_sequence_number
720: INTO v_rule_number
721: FROM IGS_EN_UNIT_SET_RULE
722: WHERE unit_set_cd = p_unit_set_cd
723: AND version_number = p_version
724: AND s_rule_call_cd = p_rule_call_name;
725: RETURN v_rule_number;

Line 1602: v_unit_set_cat IGS_EN_UNIT_SET.unit_set_cat%TYPE;

1598: FUNCTION us_attribute (
1599: p_attribute IN VARCHAR2,
1600: p_tds IN r_tds )
1601: RETURN VARCHAR2 IS
1602: v_unit_set_cat IGS_EN_UNIT_SET.unit_set_cat%TYPE;
1603: BEGIN
1604: SELECT unit_set_cat
1605: INTO v_unit_set_cat
1606: FROM IGS_EN_UNIT_SET

Line 1606: FROM IGS_EN_UNIT_SET

1602: v_unit_set_cat IGS_EN_UNIT_SET.unit_set_cat%TYPE;
1603: BEGIN
1604: SELECT unit_set_cat
1605: INTO v_unit_set_cat
1606: FROM IGS_EN_UNIT_SET
1607: WHERE unit_set_cd = p_tds.unit_cd
1608: AND version_number = p_tds.unit_version;
1609: IF p_attribute = 'usc'
1610: THEN

Line 3457: FROM IGS_EN_UNIT_SET

3453: LOOP
3454: FOR US IN (
3455: SELECT unit_set_cd,
3456: version_number
3457: FROM IGS_EN_UNIT_SET
3458: WHERE unit_set_cd LIKE (set_members.unit_cd)
3459: ORDER BY unit_set_cd,IGS_GE_NUMBER.TO_CANN(version_number) )
3460: LOOP
3461: IF in_versions(US.version_number,