APPS.PY_ZA_TAX_CERTIFICATES dependencies on PER_ASSIGNMENTS_F

Line 153: from per_assignments_f paf2

149: and (ass.assignment_id = P_EMPLOYEE or P_EMPLOYEE is null)
150: and ass.effective_start_date =
151: (
152: select max(paf2.effective_start_date)
153: from per_assignments_f paf2
154: where paf2.effective_start_date <= ppa.effective_date
155: and paf2.assignment_id = paa.assignment_id
156: )
157: and per.person_id = ass.person_id