DBA Data[Home] [Help]

APPS.PER_FR_D2_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1113: from per_assignment_status_types t,

1109: begin
1110: --
1111: select nvl(least(p_end_period,max(a.effective_end_date)),to_date('31124712','DDMMYYYY'))
1112: into l_end_date
1113: from per_assignment_status_types t,
1114: per_all_assignments_f a
1115: where a.assignment_id = p_assignment_id
1116: and a.establishment_id = p_establishment_id
1117: and a.effective_start_date <= p_end_period