DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 878: per_assignment_status_types b

874: select a.effective_start_date,
875: a.effective_end_date,
876: b.PER_SYSTEM_STATUS
877: from per_assignments_f a,
878: per_assignment_status_types b
879: where a.assignment_id = P_assignment_id
880: and a.effective_end_date between p_first_p_start_date and
881: to_date('31-12-4712','DD-MM-YYYY')
882: and a.ASSIGNMENT_STATUS_TYPE_ID =