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_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 2837: from per_all_assignments_f paa,hr_soft_coding_keyflex sck

2833:
2834:
2835: cursor csr_get_income_code is
2836: select sck.segment8,SUM(decode(sign(p_tax_year_end_date - paa.effective_end_date),-1,p_tax_year_end_date,paa.effective_end_date)-decode(sign(paa.effective_start_date - p_tax_year_start_date),-1,p_tax_year_start_date,paa.effective_start_date)+1) Days
2837: from per_all_assignments_f paa,hr_soft_coding_keyflex sck
2838: where paa.assignment_id = p_assignment_id
2839: and (paa.effective_start_date >= p_tax_year_start_date or p_tax_year_start_date between paa.effective_start_date and paa.effective_end_date)
2840: and (paa.effective_end_date <= p_tax_year_end_date or paa.effective_start_date <= p_tax_year_end_date)
2841: and sck.soft_coding_keyflex_id=paa.soft_coding_keyflex_id