VIEW: APPS.HXT_HOUR_DEDUCTION_RULES_FMV

Source

View Text - Preformatted

SELECT hdr.rowid row_id ,hdr.hdp_id ,hdr.fcl_deduction_type ,hrl.meaning ,hdr.effective_start_date ,hdr.hours ,hdr.time_period ,hdr.effective_end_date ,hdr.created_by ,hdr.creation_date ,hdr.last_updated_by ,hdr.last_update_date ,hdr.last_update_login FROM hr_lookups hrl, hxt_hour_deduction_rules hdr WHERE hrl.lookup_type(+) = 'HXT_HOUR_DEDUCTION_TYPE' AND hrl.lookup_code(+) = hdr.fcl_deduction_type AND hrl.application_id(+) = 808

View Text - HTML Formatted

SELECT HDR.ROWID ROW_ID
, HDR.HDP_ID
, HDR.FCL_DEDUCTION_TYPE
, HRL.MEANING
, HDR.EFFECTIVE_START_DATE
, HDR.HOURS
, HDR.TIME_PERIOD
, HDR.EFFECTIVE_END_DATE
, HDR.CREATED_BY
, HDR.CREATION_DATE
, HDR.LAST_UPDATED_BY
, HDR.LAST_UPDATE_DATE
, HDR.LAST_UPDATE_LOGIN
FROM HR_LOOKUPS HRL
, HXT_HOUR_DEDUCTION_RULES HDR
WHERE HRL.LOOKUP_TYPE(+) = 'HXT_HOUR_DEDUCTION_TYPE'
AND HRL.LOOKUP_CODE(+) = HDR.FCL_DEDUCTION_TYPE
AND HRL.APPLICATION_ID(+) = 808