eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_TAXOFFICE_FILE dependencies on PER_ALL_ASSIGNMENTS_F

Line 316: ,per_all_assignments_f paa

312: ,pap.full_name full_name
313: ,paa.assignment_number assignment_number
314: from pay_action_information ee_ats
315: ,per_all_people_f pap
316: ,per_all_assignments_f paa
317: WHERE ee_ats.action_context_type='AAP'
318: AND ee_ats.action_information_category = 'NL ATS EMPLOYEE DETAILS'
319: AND ee_ats.effective_date =lp_Tax_Year_End_Date
320: AND ee_ats.action_information1 =fnd_number.number_to_canonical(lp_employer_id)

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