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:
0