SELECT AA.ASSIGNMENT_ID , AA.ASSIGNMENT_ACTION_ID , AP.ACCRUAL_PLAN_ID , TP.END_DATE , PA.PAYROLL_ID , AP.BUSINESS_GROUP_ID FROM PAY_ACCRUAL_PLANS AP , PAY_ELEMENT_TYPES_F ET , PAY_ELEMENT_LINKS_F EL , PAY_ELEMENT_ENTRIES_F EE , PAY_ASSIGNMENT_ACTIONS AA , PAY_PAYROLL_ACTIONS PA , PER_TIME_PERIODS TP WHERE ET.ELEMENT_TYPE_ID = AP.ACCRUAL_PLAN_ELEMENT_TYPE_ID AND EL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID AND EE.ELEMENT_LINK_ID = EL.ELEMENT_LINK_ID AND AA.ASSIGNMENT_ID = EE.ASSIGNMENT_ID AND PA.PAYROLL_ACTION_ID = AA.PAYROLL_ACTION_ID AND TP.PAYROLL_ID = PA.PAYROLL_ID AND PA.EFFECTIVE_DATE BETWEEN TP.START_DATE AND TP.END_DATE AND PA.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE AND ET.EFFECTIVE_END_DATE AND PA.EFFECTIVE_DATE BETWEEN EL.EFFECTIVE_START_DATE AND EL.EFFECTIVE_END_DATE AND PA.EFFECTIVE_DATE BETWEEN EE.EFFECTIVE_START_DATE AND EE.EFFECTIVE_END_DATE