APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on PER_ASSIGNMENTS_F
Line 110: from per_assignments_f asg2 where
106: and iof.vacancy_id = vac.vacancy_id
107: and vac.job_id = job.job_id(+)
108: and asg.assignment_id = iof.offer_assignment_id
109: and asg.effective_start_date = (select max(effective_start_date) 110: from per_assignments_f asg2 where 111: asg.assignment_id=asg2.assignment_id
112: and asg2.effective_start_date <= trunc(sysdate))
113: and trunc(sysdate) between ppf.effective_start_date
114: and ppf.effective_end_date