HXT Total Hours To BEE

Description

Categories: BI Publisher
Columns: Batch Id1, Element Type Id, Value 1, Value 2, Value 3, Value 4, Value 5, Value 6, Value 7, Value 8 ...

Application: Time and Labor
Source: Total Hours To BEE (XML)
Short Name: HXT007A_XML
DB package: HXT_HXT007A_XMLP_PKG

Copy

SELECT pbl.batch_id batch_id1,
             pbl.element_type_id,
             pbl.value_1,
             pbl.value_2,
             pbl.value_3,
             pbl.value_4,
             pbl.value_5,
             pbl.value_6,
             pbl.value_7,
             pbl.value_8,
             pbl.value_9,
             pbl.value_10,
             pbl.value_11,
             pbl.value_12,
             pbl.value_13,
             pbl.value_14,
             pbl.value_15, 
	HXT_HXT007A_XMLP_PKG.cf_bee_line_hoursformula(pbl.element_type_id, pbl.value_1, pbl.value_2, pbl.value_3, pbl.value_4, pbl.value_5, pbl.value_6, pbl.value_7, pbl.value_8, pbl.value_9, pbl.value_10, pbl.value_11, pbl.value_12, pbl.value_13, pbl.value_14, pbl.value_15) CF_BEE_LINE_HOURS
FROM hxt_pay_element_types_f_ddf_v hpet,
             pay_batch_lines pbl
WHERE hpet.element_type_id = pbl.element_type_id
     AND :P_DATE_EARNED BETWEEN hpet.effective_start_date AND hpet.effective_end_date
     AND hpet.hxt_earning_category IN ('REG', 'OVT', 'ABS') 
 and pbl.batch_id=:batch_id