299: pay_element_types_f pet ,
300: pay_element_classifications pec ,
301: pay_run_results prr,
302: pay_input_values_f piv,
303: pay_run_result_values prrv
304: Where paa.assignment_id = p_assignment_id
305: and ppa.payroll_action_id = paa.payroll_action_id
306: and ppa.date_earned >= p_last_day_worked
307: and ppa.action_type in ('Q','R','B','I')
337: pay_input_values_f piv ,
338: pay_payroll_actions ppa,
339: pay_assignment_actions paa,
340: pay_run_results prr,
341: pay_run_result_values prrv
342: Where pet.element_type_id = piv.element_type_id
343: and ppa.payroll_action_id = paa.payroll_action_id
344: and prr.assignment_action_id = paa.assignment_action_id
345: and prr.element_type_id = pet.element_type_id