HXT Total Hours To BEE

➜ Back to Library

Description
Categories: BI Publisher, Human Resources Application: Time and Labor Source: Total Hours To BEE (XML) Short Name: HXT007A_XML DB package: HXT_HXT007A_XMLP_PKG more less

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

Parameter Name

SQL text

Validation

Process Date

Date

Payroll Name

LOV Oracle

Download

Related Blitz Reports
HXT Earning Variance Calculation HXT Location Variance Calculation HXT Organization Variance Calc HXT Actual and Rounded Time Punch HXT Person/Assignment Table List HXT OTLR Missing Timecard PO Endeca Template PON Solicitation data template HXT Work Plan Table Listing