APPS.PAY_QPE_API dependencies on PAY_PAYROLL_ACTIONS

Line 58: from pay_payroll_actions pya

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;

Line 143: v_date_earned pay_payroll_actions.date_earned%TYPE;

139: (p_rec in pay_quickpay_exclusions%ROWTYPE
140: ) is
141: --
142: v_exists varchar2(1);
143: v_date_earned pay_payroll_actions.date_earned%TYPE;
144: v_proc varchar2(72) := g_package||'validate_ele_ent_id';
145: --
146: cursor cur_exists is
147: select 'Y'

Line 159: , pay_payroll_actions pya

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
163: and ent.effective_end_date >= decode(et.proration_group_id, null, pya.date_earned,

Line 183: , pay_payroll_actions pya

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
187: and ent.effective_start_date <= pya.date_earned

Line 393: from pay_payroll_actions pya

389: --
390: --
391: cursor cur_pya_act is
392: select 'Y'
393: from pay_payroll_actions pya
394: , pay_assignment_actions aga
395: where aga.assignment_action_id = p_assignment_action_id
396: and pya.payroll_action_id = aga.payroll_action_id
397: and pya.current_task is not null;