23: FROM pay_element_types_f pet
24: ,pay_element_type_extra_info pete
25: ,pay_run_results prr
26: ,pay_assignment_actions paas
27: ,pay_payroll_actions ppa
28: where
29: pete.EEI_INFORMATION_CATEGORY='PQP_VEHICLE_MILEAGE_INFO'
30: AND pet.element_type_id=pete.element_type_id
31: AND pete.EEI_INFORMATION1 in ('C','P','CM','CP','PP','PM')
115: , pay_balance_feeds_f FEED
116: , pay_run_results RR
117: , pay_assignment_actions ASSACT
118: , pay_assignment_actions BAL_ASSACT
119: , pay_payroll_actions PACT
120: WHERE BAL_ASSACT.assignment_action_id = cp_assignment_action_id
121: AND FEED.balance_type_id = cp_balance_type_id
122: AND FEED.input_value_id = TARGET.input_value_id
123: AND TARGET.run_result_id = RR.run_result_id