You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Project field is blank for below query

Summary:

WITH hours_data AS (
SELECT
prr.payroll_assignment_id,
prr.run_result_id,
TRUNC(prr.ora_part_key) AS trx_date,
SUM(TO_NUMBER(prrv.result_value)) AS hours
FROM pay_run_results prr
JOIN pay_run_result_values prrv
ON prr.run_result_id = prrv.run_result_id
JOIN pay_input_values_f piv
ON prrv.input_value_id = piv.input_value_id
WHERE UPPER(piv.base_name) = 'HOURS'
GROUP BY
prr.payroll_assignment_id,
prr.run_result_id,
TRUNC(prr.ora_part_key)
),
base_data AS (
SELECT
pjb.project_id,
pjb.segment1 AS project,
pc.source_id,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!