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_GB_NICAR_06042002 dependencies on PAY_ELEMENT_LINKS_F

Line 1606: , pay_element_links_f LINK

1602: ,EENT.effective_end_date csr3_end_date
1603: ,EENT.effective_start_date csr3_start_date
1604:
1605: FROM pay_element_entries_f EENT
1606: , pay_element_links_f LINK
1607: , pay_element_entry_values_f V
1608: WHERE EENT.effective_end_date >= g_tax_year_start
1609: AND EENT.effective_start_date <=
1610: least(p_emp_term_date,l_end_of_period_date,g_tax_year_end)

Line 1625: pay_element_links_f pel,

1621: /* Find out if employee has opted back into free fuel part way through the tax year */
1622: CURSOR csr_ignore_fuel_opt_out IS
1623: SELECT 'Y'
1624: FROM pay_element_entries_f pee,
1625: pay_element_links_f pel,
1626: pay_element_entry_values_f peev
1627: WHERE pee.effective_start_date > g_tax_year_start
1628: AND pee.effective_start_date <= least(p_emp_term_date, l_end_of_period_date, g_tax_year_end)
1629: AND pee.assignment_id = p_assignment_id

Line 1645: pay_element_links_f pel,

1641: else return a date after end of the year */
1642: CURSOR csr_last_opt_out_date IS
1643: SELECT nvl(max(pee.effective_start_date), g_tax_year_end+1)
1644: FROM pay_element_entries_f pee,
1645: pay_element_links_f pel,
1646: pay_element_entry_values_f peev
1647: WHERE least(p_emp_term_date, l_end_of_period_date, g_tax_year_end) BETWEEN
1648: pee.effective_start_date AND pee.effective_end_date
1649: AND pee.assignment_id = p_assignment_id