APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_ATTR_GROUPS_V

Line 4618: FROM ego_attr_groups_v

4614: BEGIN
4615: --bug 7701752 : if AG is EGO_ITEMMGMT_GROUP and ItemDetailImage,ItemDetailDesc, exclude it, because it is associated by default, added by chris.zhao at 2009-01-19
4616: SELECT COUNT (*)
4617: INTO l_item_ag_count
4618: FROM ego_attr_groups_v
4619: WHERE attr_group_type = 'EGO_ITEMMGMT_GROUP' AND (attr_group_id = 1 OR attr_group_id = 2) AND attr_group_id = p_attr_group_id ;
4620:
4621: IF (l_item_ag_count > 0)
4622: THEN

Line 17858: p_ag_id IN ego_attr_groups_v.attr_group_id%TYPE)

17854: l_ix NUMBER;
17855: l_api_name VARCHAR2(30) := 'Process_Req_Attr_Results';
17856:
17857: CURSOR fetch_required_attr(
17858: p_ag_id IN ego_attr_groups_v.attr_group_id%TYPE)
17859: IS
17860: SELECT attr.attr_name,
17861: attr.attr_display_name,
17862: ag.attr_group_id,

Line 17868: ego_attr_groups_v ag

17864: ag.attr_group_disp_name,
17865: ag.attr_group_type,
17866: ag.application_id
17867: FROM ego_attrs_v attr ,
17868: ego_attr_groups_v ag
17869: WHERE ag.application_id = attr.application_id
17870: AND ag.attr_group_type = attr.attr_group_type
17871: AND ag.attr_group_name = attr.attr_group_name
17872: AND ag.attr_group_id = p_ag_id