APPS.RRS_ATTR_PANE dependencies on EGO_ATTR_GROUPS_V

Line 422: FROM EGO_ATTR_GROUPS_V

418: NUM_OF_COLS,
419: NUM_OF_ROWS,
420: l_page_entries(j).sequence)
421: INTO l_attribute_group_rec
422: FROM EGO_ATTR_GROUPS_V
423: WHERE APPLICATION_ID = 718
424: AND ATTR_GROUP_TYPE = l_page_entries(j).attr_group_type
425: AND ATTR_GROUP_NAME = l_page_entries(j).attr_group_name;
426:

Line 607: l_attr_group_id EGO_ATTR_GROUPS_V.ATTR_GROUP_ID%TYPE;

603: l_query VARCHAR2(2000);
604:
605: l_ext_table_name VARCHAR2(200);
606: l_pk_name VARCHAR2(30);
607: l_attr_group_id EGO_ATTR_GROUPS_V.ATTR_GROUP_ID%TYPE;
608:
609: l_attr_info attr_info_rec;
610: l_code_value VARCHAR2(1000);
611: l_date_value DATE;

Line 701: FROM EGO_ATTR_GROUPS_V

697: /* query attribute group id */
698: BEGIN
699: SELECT ATTR_GROUP_ID
700: INTO l_attr_group_id
701: FROM EGO_ATTR_GROUPS_V
702: WHERE APPLICATION_ID = 718
703: AND ATTR_GROUP_TYPE = p_attr_group_type
704: AND ATTR_GROUP_NAME = p_attr_group_name;
705: --DBMS_OUTPUT.PUT_LINE('l_attr_group_id: ' || l_attr_group_id);

Line 1183: FROM EGO_ATTR_GROUPS_V

1179:
1180: -- convert attribute group id to attribute group name
1181: SELECT ATTR_GROUP_TYPE, ATTR_GROUP_NAME
1182: INTO l_attr_group_type, l_attr_group_name
1183: FROM EGO_ATTR_GROUPS_V
1184: WHERE ATTR_GROUP_ID = p_attr_group_id;
1185:
1186: -- query the corresponding attribute name of the data column name
1187: SELECT ATTR_NAME

Line 1259: FROM EGO_ATTR_GROUPS_V

1255:
1256: -- convert attribute group id to attribute group name
1257: SELECT ATTR_GROUP_TYPE, ATTR_GROUP_NAME
1258: INTO l_attr_group_type, l_attr_group_name
1259: FROM EGO_ATTR_GROUPS_V
1260: WHERE ATTR_GROUP_ID = p_attr_group_id;
1261:
1262: -- query the corresponding attribute name of the data column name
1263: SELECT ATTR_NAME