We are trying to Develop Benefits Arrears Reports using BI Reports

Summary:

Hi Everyone,

We are trying to develop a Benefits Arrears Report using BI Report. If a person has benefits arrears for a particular week, we need to be able to fetch the balance value for that specific arrear with 'Relationship Inception to Date,' but we are unable to retrieve the value for 'Relationship Inception to Date.

Attaching the code for any further corrections correct me if any tables are wrong to fetch the data.

select
DISTINCT papf.person_number,
payrel.payroll_relationship_id,
TO_CHAR(TRUNC(paybal.effective_date), 'YYYY-MM-DD') as effective_date,
paybalview.balance_name,
paydim.dimension_name,