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 613: pay_payroll_actions ppa,

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

Line 625: pay_payroll_actions ppa

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

Line 734: from pay_payroll_actions ppa,

730: select pbh.batch_id,
731: pbh.business_group_id,
732: ppa.BATCH_PROCESS_MODE,
733: nvl(pbh.purge_after_rollback,'N') purge_after_rollback
734: from pay_payroll_actions ppa,
735: pay_batch_headers pbh
736: where ppa.payroll_action_id = p_payroll_action_id
737: and pbh.batch_id = ppa.batch_id
738: and ppa.action_type = 'BEE'

Line 823: pay_payroll_actions ppa,

819: if p_chk_rollback_upd = 'Y' then
820: select 'Y' into l_results_found
821: from pay_run_results prr,
822: pay_assignment_actions paa,
823: pay_payroll_actions ppa,
824: pay_element_entries_f pee
825: where prr.source_type = 'E'
826: and pee.element_entry_id = p_element_entry_id
827: and p_effective_session_date between pee.effective_start_date