FLSA status not present on table after HDL load

Summary

per_job_leg_f table

Content

Hello,

 

we mass upload via HDL jobs. Running some queries 

select 

pjlf.information1

from

per_job_leg_f pjlf,per_jobs_f pjf,per_all_assignments_m paam

where 

1=1

and pjlf.job_id= pjf.job_id

                       and pjlf.information_category = 'HRX_US_JOBS'

                         and TRUNC(SYSDATE) BETWEEN pjf.effective_start_date and pjf.effective_end_date

                          and 

  pjf.job_id = paam.job_id

                          and paam.assignment_type IN ('E','C')

                          and paam.primary_flag = 'Y'

                          and TRUNC(SYSDATE) between paam.effective_start_date and paam.effective_end_date

                         --and paam.assignment_id = 300000011788556

--and pjf.job_id =300000019752232