APPS.PAY_US_PTO_ACCRUAL dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 924: per_assignment_status_types b
920: select a.effective_start_date,
921: a.effective_end_date,
922: b.PER_SYSTEM_STATUS
923: from per_assignments_f a, 924: per_assignment_status_types b 925: where a.assignment_id = P_assignment_id
926: and a.effective_end_date between p_first_p_start_date and
927: to_date('31-12-4712','DD-MM-YYYY')
928: and a.ASSIGNMENT_STATUS_TYPE_ID =