[Home] [Help]
54: where assignment_action_id = p_assignment_action_id;
55: --
56: cursor sel_for_qpr is
57: select 'Y'
58: from pay_payroll_actions pya
59: , pay_assignment_actions asa
60: where pya.action_type = 'Q'
61: and pya.payroll_action_id = asa.payroll_action_id
62: and asa.assignment_action_id = p_assignment_action_id;
141: (p_rec in pay_quickpay_inclusions%ROWTYPE
142: ) is
143: --
144: v_exists varchar2(1);
145: v_date_earned pay_payroll_actions.date_earned%TYPE;
146: v_proc varchar2(72) := g_package||'validate_ele_ent_id';
147: --
148: cursor cur_exists is
149: select 'Y'
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
165: and ent.effective_end_date >= decode(et.proration_group_id, null, pya.date_earned,
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
189: and ent.effective_start_date <= pya.date_earned
503: and action_status in ('C', 'S');
504: --
505: cursor cur_pya_act is
506: select 'Y'
507: from pay_payroll_actions pya
508: , pay_assignment_actions aga
509: where aga.assignment_action_id = p_assignment_action_id
510: and pya.payroll_action_id = aga.payroll_action_id
511: and pya.current_task is not null;
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:
1004: * Only include those which can be processed in the run.