APPS.PY_ZA_TAX_CERTIFICATES dependencies on PER_ASSIGNMENTS_F
Line 156: from per_assignments_f paf2
152: and (ass.assignment_id = P_EMPLOYEE or P_EMPLOYEE is null)
153: and ass.effective_start_date =
154: (
155: select max(paf2.effective_start_date) 156: from per_assignments_f paf2 157: where paf2.effective_start_date <= ppa.effective_date
158: and paf2.assignment_id = paa.assignment_id
159: )
160: and per.person_id = ass.person_id