SELECT GBU.USER_NAME, 'PER', U.EMPLOYEE_ID, GBX.NAME, 'GBX', GBX.GROUPBOX_ID, to_date(NULL), to_date(NULL), NULL, 10 from GHR_GROUPBOXES GBX, GHR_GROUPBOX_USERS GBU, FND_USER U WHERE GBU.GROUPBOX_ID = GBX.GROUPBOX_ID and GBU.USER_NAME = U.USER_NAME and U.EMPLOYEE_ID is not null
SELECT GBU.USER_NAME
, 'PER'
, U.EMPLOYEE_ID
, GBX.NAME
, 'GBX'
, GBX.GROUPBOX_ID
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 10
FROM GHR_GROUPBOXES GBX
, GHR_GROUPBOX_USERS GBU
, FND_USER U
WHERE GBU.GROUPBOX_ID = GBX.GROUPBOX_ID
AND GBU.USER_NAME = U.USER_NAME
AND U.EMPLOYEE_ID IS NOT NULL
|
|
|