APPS.IGS_EN_HESA_PKG dependencies on IGS_EN_UNIT_SET

Line 1029: FROM igs_en_unit_set us,

1025: --
1026: -- cursor to get the unit set category.
1027: CURSOR cur_us_cat IS
1028: SELECT usc.s_unit_set_cat
1029: FROM igs_en_unit_set us,
1030: igs_en_unit_set_cat usc
1031: WHERE us.unit_set_cd = p_unit_set_cd AND
1032: us.version_number = p_us_version_number AND
1033: us.unit_set_cat = usc.unit_set_cat;

Line 1030: igs_en_unit_set_cat usc

1026: -- cursor to get the unit set category.
1027: CURSOR cur_us_cat IS
1028: SELECT usc.s_unit_set_cat
1029: FROM igs_en_unit_set us,
1030: igs_en_unit_set_cat usc
1031: WHERE us.unit_set_cd = p_unit_set_cd AND
1032: us.version_number = p_us_version_number AND
1033: us.unit_set_cat = usc.unit_set_cat;
1034:

Line 1035: l_us_category igs_en_unit_set_cat.s_unit_set_cat%TYPE;

1031: WHERE us.unit_set_cd = p_unit_set_cd AND
1032: us.version_number = p_us_version_number AND
1033: us.unit_set_cat = usc.unit_set_cat;
1034:
1035: l_us_category igs_en_unit_set_cat.s_unit_set_cat%TYPE;
1036:
1037: BEGIN
1038:
1039: l_us_category := NULL;