DBA Data[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_ATTR_GROUP_DL

Line 1633: FROM EGO_ATTR_GROUP_DL

1629: -- put that data level id here. --
1630: -----------------------------------------------------------
1631: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
1632: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
1633: FROM EGO_ATTR_GROUP_DL
1634: WHERE ATTR_GROUP_ID = uai.ATTR_GROUP_ID
1635: )
1636: WHERE uai.DATA_SET_ID = p_data_set_id
1637: AND uai.PROCESS_STATUS = G_PS_IN_PROCESS

Line 1642: FROM EGO_ATTR_GROUP_DL

1638: AND uai.DATA_LEVEL_ID IS NULL
1639: AND uai.DATA_LEVEL_NAME IS NULL
1640: AND uai.USER_DATA_LEVEL_NAME IS NULL
1641: AND (SELECT COUNT(*)
1642: FROM EGO_ATTR_GROUP_DL
1643: WHERE ATTR_GROUP_ID = uai.ATTR_GROUP_ID) = 1;
1644:
1645:
1646: -------------------------------------------------

Line 2071: EGO_ATTR_GROUP_DL eagd

2067: AND PROCESS_STATUS = G_PS_IN_PROCESS
2068: AND ROW_IDENTIFIER IN (SELECT ROW_IDENTIFIER
2069: FROM
2070: EGO_ITM_USR_ATTR_INTRFC intf,
2071: EGO_ATTR_GROUP_DL eagd
2072: WHERE intf.DATA_SET_ID = p_data_set_id
2073: AND intf.PROCESS_STATUS = G_PS_IN_PROCESS
2074: AND intf.ATTR_GROUP_ID = eagd.ATTR_GROUP_ID
2075: AND intf.DATA_LEVEL_ID = eagd.DATA_LEVEL_ID