DBA Data[Home] [Help]

APPS.PAY_FR_OVERTIME dependencies on PAY_ELEMENT_LINKS_F

Line 78: , pay_element_links_f el

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'
82: and p_effective_date

Line 183: , pay_element_links_f LINK

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
187: and p_date BETWEEN TARGET.effective_start_date

Line 762: , pay_element_links_f el

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
766: and el.element_type_id = et.element_type_id