DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on PAY_ELEMENT_ENTRIES_F

Line 243: from pay_element_entries_f

239: -- cursor which checks whether there is an open salary element.
240: --
241: cursor csr_sp_element_open is
242: select null
243: from pay_element_entries_f
244: where assignment_id = p_assignment_id
245: and creator_type = 'SP'
246: and effective_end_date = hr_general.end_of_time;
247: --

Line 253: from pay_element_entries_f peef

249: -- element.
250: --
251: cursor csr_element_effective_end_date is
252: select max(peef.effective_end_date)
253: from pay_element_entries_f peef
254: , pay_element_links_f pel
255: , pay_input_values_f piv
256: , per_pay_bases ppb
257: , per_all_assignments_f asg