APPS.MTH_UTIL_PKG dependencies on EGO_ATTR_GROUPS_V

Line 1999: * from EGO_ATTR_GROUPS_V for a given attribute group name. *

1995:
1996: /* ****************************************************************************
1997: * Function :GET_ATTR_GROUP_ID *
1998: * Description :This function is used to retrive attribute group ID *
1999: * from EGO_ATTR_GROUPS_V for a given attribute group name. *
2000: * File Name :MTHUTILB.PLS *
2001: * Visibility :Public
2002: * Parameters : *
2003: * p_att_grp_name: Attribute group name *

Line 2012: FROM EGO_ATTR_GROUPS_V

2008: FUNCTION GET_ATTR_GROUP_ID(p_att_grp_name IN VARCHAR2 DEFAULT 'SPECIFICATIONS'
2009: ) RETURN NUMBER IS
2010: cursor getAttrGroupId (p_att_grp_name IN VARCHAR2) is
2011: SELECT ATTR_GROUP_ID
2012: FROM EGO_ATTR_GROUPS_V
2013: WHERE application_id = 9001 AND
2014: ATTR_GROUP_TYPE = 'MTH_EQUIPMENTS_GROUP' AND
2015: attr_group_name = p_att_grp_name;
2016: v_attr_grp_id NUMBER := NULL;

Line 2510: FROM mth_tag_destination_map t, ego_attrs_v a, EGO_ATTR_GROUPS_V g

2506: RETURN NUMBER
2507: IS
2508: CURSOR c_attr_name (p_tag_code IN VARCHAR2) IS
2509: SELECT a.attr_name, t.equipment_fk_key
2510: FROM mth_tag_destination_map t, ego_attrs_v a, EGO_ATTR_GROUPS_V g
2511: WHERE t.tag_code = p_tag_code and t.attribute = a.attr_id AND
2512: t.attribute_group = g.attr_group_id AND a.application_id = 9001 AND
2513: a.application_id = g.application_id and
2514: a.attr_group_name = g.attr_group_name;