22: ,prr.run_result_id
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
113: * FEED.scale),0) tot
114: FROM pay_run_result_values TARGET
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
114: FROM pay_run_result_values TARGET
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