APPS.EGO_USER_ATTRS_BULK_PVT dependencies on EGO_DATA_LEVEL_VL

Line 1719: FROM EGO_DATA_LEVEL_VL

1715: ,PK2_COLUMN_TYPE
1716: ,PK3_COLUMN_TYPE
1717: ,PK4_COLUMN_TYPE
1718: ,PK5_COLUMN_TYPE
1719: FROM EGO_DATA_LEVEL_VL
1720: WHERE DATA_LEVEL_ID IN ( SELECT DATA_LEVEL_ID
1721: FROM EGO_ATTR_GROUP_DL
1722: WHERE ATTR_GROUP_ID = p_attr_group_id);
1723:

Line 1922: ' FROM EGO_DATA_LEVEL_VL '||

1918: ------------------------------------------------------
1919: EXECUTE IMMEDIATE
1920: ' UPDATE '||p_interface_table_name||' UAI1 '||
1921: ' SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID '||
1922: ' FROM EGO_DATA_LEVEL_VL '||
1923: ' WHERE (DATA_LEVEL_NAME = NVL(UAI1.DATA_LEVEL_NAME, CHR(0)) '||
1924: ' OR USER_DATA_LEVEL_NAME = NVL(UAI1.USER_DATA_LEVEL_NAME, CHR(0)))'||
1925: ' AND APPLICATION_ID = :application_id '||
1926: ' AND ATTR_GROUP_TYPE = :attr_group_type '||