DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on PAY_ELEMENT_TYPES_F

Line 171: , pay_element_types_f et

167: , per_people_f p /*Bug No 2920728*/
168: , per_assignments_f a
169: , hr_soft_coding_keyflex scl
170: , pay_nz_asg_cal_mth_bal_v b
171: , pay_element_types_f et
172: , pay_input_values_f iv
173: , pay_input_values_f iv1
174: , pay_input_values_f iv2
175: , pay_run_results prr

Line 228: from pay_element_types_f et2

224: and et.effective_start_date <= last_day(s.effective_date)
225: and et.effective_end_date >= to_date('01/' || to_char(s.effective_date, 'mm/yyyy'), 'dd/mm/yyyy')
226: -- the following sub query makes sure that we get the element type in effect at the end of the month
227: and et.effective_start_date = (select max(et2.effective_start_date)
228: from pay_element_types_f et2
229: where et2.element_type_id = et.element_type_id
230: and et2.effective_start_date <= last_day(s.effective_date)
231: )
232: and assact.assignment_action_id = ( select max(assact4.assignment_action_id)