APPS.OKC_CDRL_DT_PKG dependencies on EGO_ATTRS_V

Line 152: from ego_attrs_v

148: FUNCTION GET_ADDR_UDA_XML(p_delId number, p_uda_template_id number)
149: RETURN XMLType is
150: cursor c_attr is
151: select attr_name, database_column
152: from ego_attrs_v
153: where attr_group_name = 'CDRL_DIST_ADDR';
154:
155: cursor c_del is
156: select extension_id , rownum num

Line 225: FROM ego_attrs_v attr, ego_attr_groups_v grp

221: l_attr_id number;
222: BEGIN
223: SELECT attr.database_column , grp.attr_group_id, attr.data_type_code, attr.attr_id
224: INTO l_db_col, l_attr_group_id, l_data_type, l_attr_id
225: FROM ego_attrs_v attr, ego_attr_groups_v grp
226: WHERE attr.attr_group_name = p_attr_group
227: AND attr.attr_group_type = 'OKC_DELIVERABLES_EXT_ATTRS'
228: AND attr.attr_name = p_attr_name
229: AND attr.attr_group_type = grp.attr_group_type