DBA Data[Home] [Help]

APPS.PAY_QPE_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 150: from pay_element_entries_f

146: cursor cur_exists is
147: select 'Y'
148: from dual
149: where exists (select 'Y'
150: from pay_element_entries_f
151: where element_entry_id = p_rec.element_entry_id);
152: --
153: cursor cur_date is
154: select pya.date_earned

Line 158: , pay_element_entries_f ent

154: select pya.date_earned
155: from
156: pay_element_types_f et
157: , pay_element_links_f el
158: , pay_element_entries_f ent
159: , pay_payroll_actions pya
160: , pay_assignment_actions aga
161: where ent.element_entry_id = p_rec.element_entry_id
162: and ent.effective_start_date <= pya.date_earned

Line 182: , pay_element_entries_f ent

178: select 'Y'
179: from
180: pay_element_types_f et
181: , pay_element_links_f el
182: , pay_element_entries_f ent
183: , pay_payroll_actions pya
184: , pay_assignment_actions aga
185: where ent.element_entry_id = p_rec.element_entry_id
186: and ent.assignment_id = aga.assignment_id