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 FND_NUMBER

Line 320: AND ee_ats.action_information1 =fnd_number.number_to_canonical(lp_employer_id)

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)
321: AND fnd_number.canonical_to_number(ee_ats.action_information2) BETWEEN lp_start_person_id AND lp_end_person_id
322: AND paa.assignment_id = fnd_number.canonical_to_number(ee_ats.action_information3)
323: AND paa.effective_start_date =
324: (

Line 321: AND fnd_number.canonical_to_number(ee_ats.action_information2) BETWEEN lp_start_person_id AND lp_end_person_id

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)
321: AND fnd_number.canonical_to_number(ee_ats.action_information2) BETWEEN lp_start_person_id AND lp_end_person_id
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)

Line 322: AND paa.assignment_id = fnd_number.canonical_to_number(ee_ats.action_information3)

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)
321: AND fnd_number.canonical_to_number(ee_ats.action_information2) BETWEEN lp_start_person_id AND lp_end_person_id
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

Line 334: AND pap.person_id = fnd_number.canonical_to_number(ee_ats.action_information2)

330: and asg.effective_start_date <= lp_Tax_Year_End_Date
331: and nvl(asg.effective_end_date, lp_Tax_Year_End_Date) >= lp_Tax_Year_Start_Date
332:
333: )
334: AND pap.person_id = fnd_number.canonical_to_number(ee_ats.action_information2)
335: AND lp_Tax_Year_End_Date between pap.effective_start_date and pap.effective_end_date
336: AND pap.person_id = paa.person_id
337: AND not exists
338: (select arc_lck.locked_action_id from pay_action_interlocks arc_lck