3566: ,pay_assignment_actions d
3567: ,pay_payroll_actions e
3568: ,pay_run_results h
3569: ,ben_acty_base_rt_f i
3570: ,pay_input_values_f j
3571: WHERE d.assignment_id = c_assignment_id
3572: AND d.payroll_action_id = e.payroll_action_id
3573: AND i.input_value_id = j.input_value_id
3574: AND i.element_type_id = b.element_type_id
4018: select elk.costable_type,
4019: link_inp_val.element_link_id,
4020: abr.input_value_id
4021: from ben_acty_base_rt_f abr,
4022: pay_input_values_f inp_val,
4023: pay_element_links_f elk,
4024: pay_link_input_values_f link_inp_val
4025: where acty_base_rt_id = c_acty_base_rt_id
4026: and abr.input_value_id = inp_val.input_value_id
4143: ,pay_assignment_actions d
4144: ,pay_payroll_actions e
4145: ,pay_run_results h
4146: ,ben_acty_base_rt_f i
4147: ,pay_input_values_f j
4148: WHERE d.assignment_id = c_assignment_id
4149: AND d.payroll_action_id = e.payroll_action_id
4150: AND i.input_value_id = j.input_value_id
4151: AND i.element_type_id = b.element_type_id
4178: ,pay_assignment_actions d
4179: ,pay_payroll_actions e
4180: ,pay_run_results h
4181: ,ben_acty_base_rt_f i
4182: ,pay_input_values_f j
4183: WHERE d.assignment_id = c_assignment_id
4184: AND d.payroll_action_id = e.payroll_action_id
4185: AND i.input_value_id = j.input_value_id
4186: AND i.element_type_id = b.element_type_id
4216: ,pay_assignment_actions d
4217: ,pay_payroll_actions e
4218: ,pay_run_results h
4219: ,ben_acty_base_rt_f i
4220: ,pay_input_values_f j
4221: WHERE d.assignment_id = c_assignment_id
4222: AND d.payroll_action_id = e.payroll_action_id
4223: AND i.input_value_id = j.input_value_id
4224: AND i.element_type_id = b.element_type_id