DBA Data[Home] [Help]

APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 607: FROM per_all_assignments_f asg, per_assignment_status_types past

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