DBA Data[Home] [Help]

APPS.PAY_FR_OVERTIME dependencies on PAY_PAYROLLS_F

Line 80: , pay_payrolls_f p

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
83: between et.effective_start_date and et.effective_end_date
84: and el.element_type_id = et.element_type_id

Line 185: , pay_payrolls_f SCHEME

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
188: AND TARGET.effective_end_date
189: and TARGET.element_link_id = LINK.element_link_id