Product: | HXT - Time and Labor |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXT_EARNING_POLICIES_FMV |
SELECT HEP.ROWID ROW_ID
, HEP.ID
, HEP.HCL_ID
, HEP.FCL_EARN_TYPE
, HRL.MEANING
, HEP.USE_POINTS_ASSIGNED
, HEP.NAME
, HEP.EFFECTIVE_START_DATE
, HEP.PIP_ID
, HEP.PEP_ID
, HEP.EGT_ID
, HEP.DESCRIPTION
, HEP.EFFECTIVE_END_DATE
, HEP.CREATED_BY
, HEP.CREATION_DATE
, HEP.LAST_UPDATED_BY
, HEP.LAST_UPDATE_DATE
, HEP.LAST_UPDATE_LOGIN
, HEP.ORGANIZATION_ID
, HEP.ROUND_UP
, HEP.MIN_TCARD_INTVL
, HEP.BUSINESS_GROUP_ID /*HXT11I1*/
FROM HR_LOOKUPS HRL
, HXT_EARNING_POLICIES HEP
WHERE HRL.LOOKUP_TYPE(+) = 'HXT_EARNING_RULE'
AND HRL.LOOKUP_CODE(+) = HEP.FCL_EARN_TYPE
AND HRL.APPLICATION_ID(+) = 808