49: hta.attribute4,
50: hta.attribute5,
51: hta.attribute6,
52: hta.attribute7,
53: DECODE (TBB.DATE_TO, HR_GENERAL.end_of_time, nvl (tbb.measure,
54: TO_NUMBER (tbb.stop_time - tbb.start_time) * 24 ) ,
55: 0 ) measure,
56: hld.timecard_id
57: FROM hxc_pay_latest_details hld,
93: hta.attribute4,
94: hta.attribute5,
95: hta.attribute6,
96: hta.attribute7,
97: DECODE (TBB.DATE_TO, HR_GENERAL.end_of_time, nvl (tbb.measure,
98: TO_NUMBER (tbb.stop_time - tbb.start_time) * 24 ) ,
99: 0 ) measure,
100: hld.timecard_id
101: FROM hxc_pa_latest_details hld,