APPS.ENG_CHANGE_ATTR_UTIL dependencies on EGO_DATA_LEVEL_B

Line 893: IF l_DataLevelColumnExists = 'Y' THEN l_dynamic_sql := l_dynamic_sql || ' , ego_data_level_b DATA_LEVELS ';

889: ELSE
890: l_dynamic_sql := l_dynamic_sql || ', PEND.EXTENSION_ID ';
891: END IF;
892: l_dynamic_sql := l_dynamic_sql || ' FROM '|| p_alternate_ext_vl_name ||' PEND , '|| p_prod_vl_name||' PROD';
893: IF l_DataLevelColumnExists = 'Y' THEN l_dynamic_sql := l_dynamic_sql || ' , ego_data_level_b DATA_LEVELS ';
894: END IF;
895: l_dynamic_sql := l_dynamic_sql ||' WHERE PEND.EXTENSION_ID = PROD.EXTENSION_ID '||
896: ' AND PEND.EXTENSION_ID <> :1' ;
897: END IF;

Line 2728: SELECT DATA_LEVEL_ID FROM EGO_DATA_LEVEL_B WHERE DATA_LEVEL_NAME = dataLevelName;

2724: l_data_level_pk3 NUMBER := -1;
2725: l_data_level_pk4 NUMBER := -1;
2726: l_data_level_pk5 NUMBER := -1;
2727: CURSOR c_getDataLevelId(dataLevelName IN VARCHAR2) IS
2728: SELECT DATA_LEVEL_ID FROM EGO_DATA_LEVEL_B WHERE DATA_LEVEL_NAME = dataLevelName;
2729: BEGIN
2730: l_dynamic_sql := 'WHERE CHANGE_ID= :1 '
2731: || 'AND CHANGE_LINE_ID= :2 ';
2732: