[Home] [Help]
148: cursor cur_exists is
149: select 'Y'
150: from dual
151: where exists (select 'Y'
152: from pay_element_entries_f
153: where element_entry_id = p_rec.element_entry_id);
154: --
155: cursor cur_date is
156: select pya.date_earned
156: select pya.date_earned
157: from
158: pay_element_types_f et
159: , pay_element_links_f el
160: , pay_element_entries_f ent
161: , pay_payroll_actions pya
162: , pay_assignment_actions aga
163: where ent.element_entry_id = p_rec.element_entry_id
164: and ent.effective_start_date <= pya.date_earned
180: select 'Y'
181: from
182: pay_element_types_f et
183: , pay_element_links_f el
184: , pay_element_entries_f ent
185: , pay_payroll_actions pya
186: , pay_assignment_actions aga
187: where ent.element_entry_id = p_rec.element_entry_id
188: and ent.assignment_id = aga.assignment_id
204: cursor cur_inrun (p_date_earned date) is
205: select 'Y'
206: from pay_element_types_f ety
207: , pay_element_links_f elk
208: , pay_element_entries_f ent
209: where /* Element Types */
210: ety.process_in_run_flag = 'Y'
211: and ety.element_type_id = elk.element_type_id
212: and p_date_earned between ety.effective_start_date
225: and ent.element_entry_id = p_rec.element_entry_id;
226: --
227: cursor cur_entry (p_date_earned date) is
228: select 'Y'
229: from pay_element_entries_f
230: where p_date_earned between effective_start_date
231: and effective_end_date
232: and entry_type in ('B', 'A', 'R')
233: and element_entry_id = p_rec.element_entry_id;
235: cursor cur_fur_ele (p_date_earned date) is
236: select 'Y'
237: from pay_element_types_f ety
238: , pay_element_links_f elk
239: , pay_element_entries_f ent
240: where /*
241: * Element Types
242: */
243: ety.element_type_id = elk.element_type_id
995: ent.element_entry_id
996: , asa.assignment_action_id
997: from pay_element_types_f ety
998: , pay_element_links_f elk
999: , pay_element_entries_f ent
1000: , pay_payroll_actions pya
1001: , pay_assignment_actions asa
1002: where /*
1003: * Element Type: