HXT Total Hours To BEE
Description
Categories: BI Publisher
Application: Time and Labor
Source: Total Hours To BEE (XML)
Short Name: HXT007A_XML
DB package: HXT_HXT007A_XMLP_PKG
Source: Total Hours To BEE (XML)
Short Name: HXT007A_XML
DB package: HXT_HXT007A_XMLP_PKG
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Payroll Name |
|
LOV Oracle | |
Process Date |
|
Date |