APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 202: from pay_payroll_actions pact

198: l_ctl_rec csr_control_lines%ROWTYPE;
199:
200: cursor csr_pay_act_exists (p_batch_id number) is
201: select 'Y'
202: from pay_payroll_actions pact
203: where pact.batch_id = p_batch_id
204: and pact.action_type = 'BEE';
205:
206: l_pay_act_exists varchar2(1) := 'N';

Line 211: from pay_payroll_actions pact

207:
208: cursor csr_payroll_action_exists is
209: select pact.payroll_action_id,
210: pact.business_group_id
211: from pay_payroll_actions pact
212: where pact.batch_id = p_batch_header_id
213: and pact.action_type = 'BEE'
214: and pact.batch_process_mode = 'TRANSFER';
215:

Line 233: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

229:
230: l_chk_entry_modified varchar2(1);
231: l_chk_rollback_upd varchar2(1);
232:
233: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
234: l_assignment_id per_assignments_f.assignment_id%TYPE;
235: l_request_id number := 0;
236: l_entry_exists varchar2(1) := 'N';
237:

Line 614: pay_payroll_actions ppa,

610: nvl(pbh.reject_if_results_exists,'Y') reject_if_results_exists,
611: nvl(pbh.purge_after_rollback,'Y') leave_batch,
612: pbh.batch_status
613: from pay_assignment_actions pac,
614: pay_payroll_actions ppa,
615: pay_batch_headers pbh
616: where pac.assignment_action_id = p_asg_action_id
617: and ppa.payroll_action_id = pac.payroll_action_id
618: and pbh.batch_id = ppa.batch_id

Line 627: pay_payroll_actions ppa

623: 'Y' reject_if_results_exists,
624: 'Y' leave_batch,
625: 'T' batch_status
626: from pay_assignment_actions pac,
627: pay_payroll_actions ppa
628: where pac.assignment_action_id = p_asg_action_id
629: and ppa.payroll_action_id = pac.payroll_action_id
630: and ppa.action_type = 'BEE'
631: and not exists

Line 764: from pay_payroll_actions ppa,

760: select pbh.batch_id,
761: pbh.business_group_id,
762: ppa.BATCH_PROCESS_MODE,
763: nvl(pbh.purge_after_rollback,'N') purge_after_rollback
764: from pay_payroll_actions ppa,
765: pay_batch_headers pbh
766: where ppa.payroll_action_id = p_payroll_action_id
767: and pbh.batch_id = ppa.batch_id
768: and ppa.action_type = 'BEE'

Line 886: pay_payroll_actions ppa,

882: if p_chk_rollback_upd = 'Y' then
883: select 'Y' into l_results_found
884: from pay_run_results prr,
885: pay_assignment_actions paa,
886: pay_payroll_actions ppa,
887: pay_element_entries_f pee
888: where prr.source_type = 'E'
889: and pee.element_entry_id = p_element_entry_id
890: and p_effective_session_date between pee.effective_start_date