DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on PAY_ELEMENT_ENTRIES_F

Line 244: from pay_element_entries_f

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

Line 254: from pay_element_entries_f peef

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