Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_APPROVAL_PERIOD_COMPS_V |
SELECT HAPC.ROWID ROW_ID
, HAPC.APPROVAL_PERIOD_COMP_ID
, HAPC.APPROVAL_PERIOD_SET_ID
, HAPC.TIME_RECIPIENT_ID
, HTR.NAME TIME_RECIPIENT_NAME
, HAPC.RECURRING_PERIOD_ID
, HRP.NAME RECURRING_PERIOD_NAME
, HAPC.OBJECT_VERSION_NUMBER
, HAPC.CREATED_BY
, HAPC.CREATION_DATE
, HAPC.LAST_UPDATED_BY
, HAPC.LAST_UPDATE_DATE
, HAPC.LAST_UPDATE_LOGIN
FROM HXC_TIME_RECIPIENTS HTR
, HXC_RECURRING_PERIODS HRP
, HXC_APPROVAL_PERIOD_COMPS HAPC
WHERE HRP.RECURRING_PERIOD_ID = HAPC.RECURRING_PERIOD_ID
AND HTR.TIME_RECIPIENT_ID = HAPC.TIME_RECIPIENT_ID