DBA Data[Home] [Help]

APPS.PAY_GB_RTI_NINO_REPLY_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 483: per_assignment_extra_info paei where

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
487: and paei.AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION'