[Home] [Help]
APPS.BEN_CWB_SINGLE_PER_PROCESS_PKG dependencies on PER_PERIODS_OF_PLACEMENT
Line 455: from per_periods_of_placement
451: select date_start
452: ,actual_termination_date
453: ,final_process_date
454: ,projected_termination_date
455: from per_periods_of_placement
456: where person_id = p_person_id
457: and p_effective_date between date_start
458: and nvl(actual_termination_date,to_date('4712/12/31','yyyy/mm/dd'));
459: