DBA Data[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: