DBA Data[Home] [Help]

APPS.PAY_GB_NICAR_06042002 dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1607: , pay_element_entry_values_f V

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)
1611: AND EENT.assignment_id = p_assignment_id

Line 1626: pay_element_entry_values_f peev

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
1630: AND pel.element_type_id = p_element_type_id

Line 1646: pay_element_entry_values_f peev

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
1650: AND pel.element_type_id = p_element_type_id