DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PYSA dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1821: ,pay_element_entry_values_f eev1

1817: ,pay_element_links_f el
1818: ,pay_element_types_f et
1819: ,pay_input_values_f iv1
1820: ,pay_element_entries_f ee
1821: ,pay_element_entry_values_f eev1
1822: WHERE asg1.assignment_id = p_assignment_id
1823: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
1824: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date
1825: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date

Line 1849: ,pay_element_entry_values_f eev1

1845: ,pay_element_links_f el
1846: ,pay_element_types_f et
1847: ,pay_input_values_f iv1
1848: ,pay_element_entries_f ee
1849: ,pay_element_entry_values_f eev1
1850: WHERE asg1.assignment_id = p_assignment_id
1851: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date
1852: AND et.element_name = 'Tax'
1853: AND et.legislation_code = 'FI'