APPS.HR_DE_VALIDATE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 19: FROM pay_element_types_f ele

15: FROM pay_element_entries_f entry
16: WHERE entry.assignment_id = p_assignment_id
17: AND p_effective_date between entry.effective_start_date and entry.effective_end_date
18: AND entry.element_type_id = (SELECT element_type_id
19: FROM pay_element_types_f ele
20: WHERE p_effective_date between ele.effective_start_date and ele.effective_end_date
21: AND ele.element_name = 'Tax Information'
22: AND ele.legislation_code = 'DE')
23: AND entry.entry_information_category = 'DE_TAX INFORMATION';

Line 67: FROM pay_element_types_f ele

63: FROM pay_element_entries_f entry
64: WHERE entry.assignment_id = l_assignment_id
65: AND p_effective_date between entry.effective_start_date and entry.effective_end_date
66: AND entry.element_type_id = (SELECT element_type_id
67: FROM pay_element_types_f ele
68: WHERE p_effective_date between ele.effective_start_date and ele.effective_end_date
69: AND ele.element_name = 'Tax Information'
70: AND ele.legislation_code = 'DE')
71: AND entry.entry_information_category = 'DE_TAX INFORMATION';