APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_ATTR_GROUP_DL

Line 1316: FROM EGO_ATTR_GROUP_DL

1312: -- put that data level id here. --
1313: -----------------------------------------------------------
1314: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1315: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
1316: FROM EGO_ATTR_GROUP_DL
1317: WHERE ATTR_GROUP_ID = uai.ATTR_GROUP_ID
1318: )
1319: WHERE uai.DATA_SET_ID = p_data_set_id
1320: AND uai.PROCESS_STATUS = G_PS_IN_PROCESS

Line 1325: FROM EGO_ATTR_GROUP_DL

1321: AND uai.DATA_LEVEL_ID IS NULL
1322: AND uai.DATA_LEVEL_NAME IS NULL
1323: AND uai.USER_DATA_LEVEL_NAME IS NULL
1324: AND (SELECT COUNT(*)
1325: FROM EGO_ATTR_GROUP_DL
1326: WHERE ATTR_GROUP_ID = uai.ATTR_GROUP_ID) = 1;
1327:
1328:
1329: -------------------------------------------------

Line 1641: EGO_ATTR_GROUP_DL eagd

1637: AND PROCESS_STATUS = G_PS_IN_PROCESS
1638: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER
1639: FROM
1640: EGO_ITM_USR_ATTR_INTRFC intf,
1641: EGO_ATTR_GROUP_DL eagd
1642: WHERE intf.DATA_SET_ID = p_data_set_id
1643: AND intf.PROCESS_STATUS = G_PS_IN_PROCESS
1644: AND intf.ATTR_GROUP_ID = eagd.ATTR_GROUP_ID
1645: AND intf.DATA_LEVEL_ID = eagd.DATA_LEVEL_ID