DBA Data[Home] [Help]

APPS.PO_UDA_PUB dependencies on EGO_ATTR_GROUPS_V

Line 130: from ego_attr_groups_v

126: l_attr_grp_id := p_attr_grp_id;
127:
128: select attr_group_name, MULTI_ROW_CODE
129: into l_attr_grp_name, l_multi_row_code
130: from ego_attr_groups_v
131: where ATTR_GROUP_TYPE = l_attr_group_Type
132: and attr_group_id = l_attr_grp_id;
133:
134: elsif p_attr_grp_int_name is not null then

Line 139: from ego_attr_groups_v

135: l_attr_grp_name := p_attr_grp_int_name;
136:
137: select attr_group_id, MULTI_ROW_CODE
138: into l_attr_grp_id, l_multi_row_code
139: from ego_attr_groups_v
140: where ATTR_GROUP_TYPE = l_attr_group_Type
141: and attr_group_name = l_attr_grp_name;
142:
143: else

Line 554: from ego_attr_groups_v

550:
551: if p_attr_grp_int_name is not null and p_attr_grp_id is null then
552: select attr_group_id, attr_group_name, attr_group_type, application_id
553: into l_attr_grp_id, l_ag_name, l_ag_type, l_appl_id
554: from ego_attr_groups_v
555: where ATTR_GROUP_TYPE = l_attr_group_Type
556: and attr_group_name = p_attr_grp_int_name;
557: else
558: select attr_group_id, attr_group_name, attr_group_type, application_id

Line 560: from ego_attr_groups_v

556: and attr_group_name = p_attr_grp_int_name;
557: else
558: select attr_group_id, attr_group_name, attr_group_type, application_id
559: into l_attr_grp_id, l_ag_name, l_ag_type, l_appl_id
560: from ego_attr_groups_v
561: where ATTR_GROUP_TYPE = l_attr_group_Type
562: and attr_group_id = p_attr_grp_id;
563: end if;
564: exception