APPS.PAY_NZ_EMS dependencies on PAY_ELEMENT_TYPES_F

Line 218: , pay_element_types_f et

214: , per_people_f p /*Bug No 2920728*/
215: , per_assignments_f a
216: , hr_soft_coding_keyflex scl
217: , pay_nz_asg_cal_mth_bal_v b
218: , pay_element_types_f et
219: , pay_input_values_f iv
220: , pay_input_values_f iv1
221: -- , pay_input_values_f iv2 /* 7480679 */
222: , pay_run_results prr

Line 275: and et.effective_start_date = (select /*+ INDEX(et2,PAY_ELEMENT_TYPES_F_PK) */ max(et2.effective_start_date)

271: and et.element_name in ('PAYE Information', 'Withholding Tax Information Record')
272: and et.effective_start_date <= last_day(s.effective_date)
273: and et.effective_end_date >= to_date('01/' || to_char(s.effective_date, 'mm/yyyy'), 'dd/mm/yyyy')
274: -- the following sub query makes sure that we get the element type in effect at the end of the month
275: and et.effective_start_date = (select /*+ INDEX(et2,PAY_ELEMENT_TYPES_F_PK) */ max(et2.effective_start_date)
276: from pay_element_types_f et2
277: where et2.element_type_id = et.element_type_id
278: and et2.effective_start_date <= last_day(s.effective_date)
279: and et2.effective_end_date > et2.effective_start_date

Line 276: from pay_element_types_f et2

272: and et.effective_start_date <= last_day(s.effective_date)
273: and et.effective_end_date >= to_date('01/' || to_char(s.effective_date, 'mm/yyyy'), 'dd/mm/yyyy')
274: -- the following sub query makes sure that we get the element type in effect at the end of the month
275: and et.effective_start_date = (select /*+ INDEX(et2,PAY_ELEMENT_TYPES_F_PK) */ max(et2.effective_start_date)
276: from pay_element_types_f et2
277: where et2.element_type_id = et.element_type_id
278: and et2.effective_start_date <= last_day(s.effective_date)
279: and et2.effective_end_date > et2.effective_start_date
280: )