DBA Data[Home] [Help]

APPS.PAY_GB_NICAR_06042002 dependencies on PAY_ELEMENT_ENTRIES_F

Line 1605: FROM pay_element_entries_f EENT

1601: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_co2
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 <=

Line 1624: FROM pay_element_entries_f pee,

1620:
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)

Line 1644: FROM pay_element_entries_f pee,

1640: /* If employee has currently opted out of the free fuel then find out the start date of this change
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