APPS.ENG_CHANGE_ATTR_UTIL dependencies on EGO_DATA_LEVEL_B

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

897: ELSE
898: l_dynamic_sql := l_dynamic_sql || ', PEND.EXTENSION_ID ';
899: END IF;
900: l_dynamic_sql := l_dynamic_sql || ' FROM '|| p_alternate_ext_vl_name ||' PEND , '|| p_prod_vl_name||' PROD';
901: IF l_DataLevelColumnExists = 'Y' THEN l_dynamic_sql := l_dynamic_sql || ' , ego_data_level_b DATA_LEVELS ';
902: END IF;
903: l_dynamic_sql := l_dynamic_sql ||' WHERE PEND.EXTENSION_ID = PROD.EXTENSION_ID '||
904: ' AND PEND.EXTENSION_ID <> :1' ;
905: END IF;

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

2755: l_data_level_pk3 NUMBER := -1;
2756: l_data_level_pk4 NUMBER := -1;
2757: l_data_level_pk5 NUMBER := -1;
2758: CURSOR c_getDataLevelId(dataLevelName IN VARCHAR2) IS
2759: SELECT DATA_LEVEL_ID FROM EGO_DATA_LEVEL_B WHERE DATA_LEVEL_NAME = dataLevelName;
2760: BEGIN
2761: l_dynamic_sql := 'WHERE CHANGE_ID= :1 '
2762: || 'AND CHANGE_LINE_ID= :2 ';
2763: