APPS.PAY_GB_RTI_NINO_REPLY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 482: select 1 from per_all_assignments_f paaf ,

478: -- Payroll id if present should match with one of the payroll id of the assignments for this person
479: and ( p_payroll_id is null
480: OR
481: exists (
482: select 1 from per_all_assignments_f paaf ,
483: per_assignment_extra_info paei where
484: paaf.person_id = pap.person_id
485: and p_date_issued between paaf.effective_start_date and paaf.effective_end_date
486: and paaf.assignment_id = paei.assignment_id