1548: -- Fetching the class code col name --
1549: --------------------------------------
1550: SELECT CLASSIFICATION_COL_NAME, CLASSIFICATION_COL_TYPE
1551: INTO l_class_code_column_name, l_class_code_column_type
1552: FROM EGO_FND_OBJECTS_EXT
1553: WHERE OBJECT_NAME = p_object_name;
1554:
1555: ----------------------------------------------------------
1556: -- Get the B, TL, and VL names for this Attr Group Type --
7372: code_debug(l_api_name||' l_ext_templrtcq_pk_join: '||l_ext_templrtcq_pk_join);
7373:
7374: SELECT classification_col_name, classification_col_type
7375: INTO l_class_code_column_name, l_class_code_column_type
7376: FROM ego_fnd_objects_ext
7377: WHERE object_name = p_object_name;
7378: code_debug(l_api_name||' l_class_code_column_name: ' ||l_class_code_column_name);
7379:
7380: -- adding the class code column
8376: ------------------------------------------------------------
8377:
8378: SELECT CLASSIFICATION_COL_NAME
8379: INTO l_class_code_column_name
8380: FROM EGO_FND_OBJECTS_EXT
8381: WHERE OBJECT_NAME = p_object_name;
8382:
8383: ----------------------------------------------------------
8384: -- Building the SQL --