APPS.PER_ASSIGNMENTS_F2_PKG dependencies on PER_PERIODS_OF_PLACEMENT

Line 299: from per_periods_of_placement pdp

295: and P_SESS_DATE between
296: p.date_start and nvl(p.final_process_date, P_END_OF_TIME)
297: union
298: select pdp.date_start date_start, to_number(null)
299: from per_periods_of_placement pdp
300: where pdp.person_id = P_PERSON_ID
301: and P_SESS_DATE between
302: pdp.date_start and nvl(pdp.final_process_date, p_end_of_time)
303: order by date_start desc;