Trying to create a BI report to fetch out the payroll element entry data for employee.

Here the data is flowing from ORC to Individual Compensation.When the employee is hired he will be awarded with some "BONUS" with some additional fields these data's will come and stored in individual compensation (i.e. : Award Compensation) and in element entri

While hiring an employee, the employee is on pending worker state once he is converted into employee the pending worker record will goes to INACTIVE state the employee record will be in ACTIVE. When the employee is hired as a pending worker he will be rewarded with "BONUS". Once the employee is converted from pending worker to employee this BONUS will reflect in individual compensation (i.e. : Award Compensation).Here in query the active record for that employee is not at all capturing in report even if we hardcode assignment_type as 'E' and status as 'ACTIVE".