DBA Data[Home] [Help]

APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 606: FROM per_all_assignments_f asg, per_assignment_status_types past

602:
603: BEGIN
604:
605: SELECT 1 INTO l_active_asg_flag
606: FROM per_all_assignments_f asg, per_assignment_status_types past
607: WHERE asg.assignment_id = l_assignment_id
608: and past.assignment_status_type_id = asg.assignment_status_type_id
609: and past.per_system_status = 'ACTIVE_ASSIGN'
610: and asg.effective_start_date <= l_Tax_Year_End_Date