APPS.PAY_US_PTO_ACCRUAL dependencies on PER_ASSIGNMENTS_F

Line 923: from per_assignments_f a,

919: CURSOR csr_all_asg_status is
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')