DBA Data[Home] [Help]

APPS.PAY_NL_TAXOFFICE_FILE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 326: FROM per_assignment_status_types past, per_all_assignments_f asg

322: AND paa.assignment_id = fnd_number.canonical_to_number(ee_ats.action_information3)
323: AND paa.effective_start_date =
324: (
325: SELECT MIN(asg.effective_start_date)
326: FROM per_assignment_status_types past, per_all_assignments_f asg
327: WHERE asg.assignment_id = paa.assignment_id
328: and past.per_system_status = 'ACTIVE_ASSIGN'
329: and asg.assignment_status_type_id = past.assignment_status_type_id
330: and asg.effective_start_date <= lp_Tax_Year_End_Date