DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 7741: PER_ASSIGNMENT_STATUS_TYPES sts

7737: --Fix for Bug: 14778369 to get all status other than termination
7738: CURSOR csr_asg IS
7739: SELECT MAX(paaf.effective_end_date) effective_end_date
7740: FROM per_all_assignments_f paaf,
7741: PER_ASSIGNMENT_STATUS_TYPES sts
7742: WHERE paaf.business_group_id = p_business_group_id
7743: AND paaf.assignment_id = p_asg_id
7744: --AND paaf.assignment_status_type_id = 1; --Fix for Bug: 14778369
7745: And paaf.effective_start_date <= p_pay_proc_period_end_date