DBA Data[Home] [Help]

APPS.PAY_FR_OVERTIME dependencies on PAY_ELEMENT_ENTRIES_F

Line 77: from pay_element_entries_f ee

73: ,ee.effective_start_date) start_date
74: , least(end_of_year
75: ,p.effective_end_date
76: ,ee.effective_end_date) end_date
77: from pay_element_entries_f ee
78: , pay_element_links_f el
79: , pay_element_types_f et
80: , pay_payrolls_f p
81: where et.element_name = 'FR_OVERTIME'

Line 182: from pay_element_entries_f TARGET

178: ,PRL_INFORMATION16 -- Regularisation_Payment_Basis
179: ,nvl(TARGET.ENTRY_INFORMATION4,PRL_INFORMATION17) -- Regularisation_Start_Date
180: ,nvl(PRL_INFORMATION18,'-1') -- Overtime Formula ID
181: ,nvl(PRL_INFORMATION19,'-1') -- Regularisation Formula ID
182: from pay_element_entries_f TARGET
183: , pay_element_links_f LINK
184: , pay_element_types_f ELEMENT
185: , pay_payrolls_f SCHEME
186: where TARGET.assignment_id = p_assignment_id

Line 761: from pay_element_entries_f ee

757: ,p_week_end_date date) return varchar2 is
758: --
759: cursor c_overtime_entry is
760: select 'Y'
761: from pay_element_entries_f ee
762: , pay_element_links_f el
763: , pay_element_types_f et
764: where ee.assignment_id = p_assignment_id
765: and ee.element_link_id = el.element_link_id