APPS.PER_ASSIGNMENTS_F2_PKG dependencies on PER_PERIODS_OF_PLACEMENT
Line 295: from per_periods_of_placement pdp
291: and P_SESS_DATE between
292: p.date_start and nvl(p.final_process_date, P_END_OF_TIME)
293: union
294: select pdp.date_start date_start, to_number(null) 295: from per_periods_of_placement pdp 296: where pdp.person_id = P_PERSON_ID
297: and P_SESS_DATE between
298: pdp.date_start and nvl(pdp.final_process_date, p_end_of_time)
299: order by date_start desc;