ERROR HAS OCCURED ON THIS PAGE. Please contact IS Helpdesk ext. 775-3070.
ERROR:
SELECT /* fmlaCheck.xsql, 108528 */ emp.employee emp_num, emp.company, initcap(emp.nick_name) fname, emp.ws_userid, upper(emp.work_state) work_state, emp.email_address email_address, round((trunc(sysdate)-emp.date_hired) / 7) weeks_worked,
(CASE emp.exempt_emp WHEN 'Y' THEN 2080*emp.fte_total ELSE (
SELECT sum(hours) hours FROM (
SELECT sum(h.timeinseconds/3600) hours FROM vp_totals h
WHERE to_char(h.personnum) = to_char()
AND trunc(h.adjustedapplydate) between to_date(to_char(sysdate-365,'mm/dd/yyyy'),'mm/dd/yyyy') and to_date(to_char(sysdate,'mm/dd/yyyy'),'mm/dd/yyyy')
AND h.paycodeid in (SELECT /*wi*/ lookup_id AS paycodeid FROM tbl_fmla_lookup WHERE lookup_group = 'PayCodeID' AND sort_ind = 1 AND active_ind = 'A')
UNION
SELECT sum(vph.timeinseconds/3600) hours FROM tbl_vp_totals_fmla_hist vph
WHERE to_char(vph.personnum) = to_char()
AND trunc(vph.adjustedapplydate) between to_date(to_char(sysdate-365,'mm/dd/yyyy'),'mm/dd/yyyy') and to_date(to_char(sysdate,'mm/dd/yyyy'),'mm/dd/yyyy')
AND vph.paycodeid in (1,4,7,8,10,11)
)
)
END ) hours_worked_fed,
(CASE emp.exempt_emp WHEN 'Y' THEN 2080*emp.fte_total ELSE (
SELECT sum(hours) hours FROM (
SELECT sum(h.timeinseconds/3600) hours FROM vp_totals h
WHERE to_char(h.personnum) = to_char()
AND trunc(h.adjustedapplydate) between to_date(to_char(sysdate-365,'mm/dd/yyyy'),'mm/dd/yyyy') and to_date(to_char(sysdate,'mm/dd/yyyy'),'mm/dd/yyyy')
AND h.paycodeid in (SELECT lookup_id AS paycodeid FROM tbl_fmla_lookup WHERE lookup_group = 'PayCodeID' AND active_ind = 'A')
UNION
SELECT sum(vph.timeinseconds/3600) hours FROM tbl_vp_totals_fmla_hist vph
WHERE to_char(vph.personnum) = to_char()
AND trunc(vph.adjustedapplydate) between to_date(to_char(sysdate-365,'mm/dd/yyyy'),'mm/dd/yyyy') and to_date(to_char(sysdate,'mm/dd/yyyy'),'mm/dd/yyyy')
AND vph.paycodeid in (1,4,7,8,10,11,16,17,21,22,24,26,3302,4102)
)
)
END) hours_worked_wi,
(SELECT 'P' FROM tbl_employee_master emp2 WHERE emp.employee = emp2.employee
AND emp2.job_code IN (SELECT lookup_id FROM tbl_fmla_lookup WHERE lookup_group = 'ProvJobCode' AND active_ind = 'A')
) prov_ind
FROM tbl_employee_master emp
WHERE emp.novell_userid = lower(?)
AND emp.emp_status IN (SELECT lookup_description FROM tbl_fmla_lookup WHERE lookup_group = 'EmpStatusCode' AND active_ind = 'A')
ORA-00938: not enough arguments for function
Page Parameters:
Name = Host Server; Value = unknown host
Please wait while I check your eligibility