DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PER_ASSIGNMENTS_F

Line 877: from per_assignments_f a,

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