DBA Data[Home] [Help]

APPS.PAY_IE_P60XML dependencies on PER_ALL_ASSIGNMENTS_F

Line 387: from per_all_assignments_f asg2

383: and paf.business_group_id + 0 = p_business_group_id /*4483028*/
384: -- Bug 3446744 Checking if the employee has been terminated before issuing the P60
385: and (pps.actual_termination_date is null or pps.actual_termination_date >= cp_end_date)
386: and paf.effective_start_date = (select max(asg2.effective_start_date)
387: from per_all_assignments_f asg2
388: where asg2.assignment_id = paf.assignment_id
389: and asg2.effective_start_date <= cp_end_date
390: and nvl(asg2.effective_end_date, to_date('31-12-4712','DD-MM-RRRR')) >= cp_start_date)
391: /*bug 3595646*/