APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_BATCH_HEADERS

Line 102: from pay_batch_headers pbh

98: to_date(null) effective_start_date
99: from dual
100: where not exists
101: (select null
102: from pay_batch_headers pbh
103: where pbh.batch_id = p_batch_header_id);
104:
105: cursor c_batch_entries (c_assignment_id number) is
106: select pee.element_entry_id, pee.creator_type,

Line 284: from pay_batch_headers

280: hr_utility.set_location('pay_mix_rollback_pkg.undo_mix',20);
281:
282: select 'Y'
283: into l_check_batch_id
284: from pay_batch_headers
285: where batch_id = p_batch_header_id
286: and batch_status = 'T';
287:
288: -- Get business_group_id

Line 299: from pay_batch_headers

295: into l_business_group_id,
296: l_reject_ent_not_removed,
297: l_allow_rollback,
298: l_DATE_EFFECTIVE_CHANGES
299: from pay_batch_headers
300: where batch_id = p_batch_header_id;
301:
302: exception
303: when no_data_found then

Line 509: update pay_batch_headers

505: -- processes.
506: --
507: if p_asg_action_id is null then
508: -- -- Change batch header status to 'unprocessed'
509: update pay_batch_headers
510: set batch_status = 'U'
511: where batch_id = p_batch_header_id;
512: --
513: update pay_batch_control_totals

Line 615: pay_batch_headers pbh

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
619: and ppa.action_type = 'BEE'

Line 633: from pay_batch_headers pbh1

629: and ppa.payroll_action_id = pac.payroll_action_id
630: and ppa.action_type = 'BEE'
631: and not exists
632: (select null
633: from pay_batch_headers pbh1
634: where pbh1.batch_id = ppa.batch_id);
635: --
636: cursor csr_reset_control_total (p_batch_id number) is
637: select 'Y'

Line 651: from pay_batch_headers pbh

647: where pbl.batch_id = p_batch_id
648: and pbl.batch_line_status <> 'T')
649: and exists
650: (select null
651: from pay_batch_headers pbh
652: where pbh.batch_id = p_batch_id
653: and pbh.batch_status = 'T');
654: --
655: cursor csr_control_lines (p_batch_id number) is

Line 765: pay_batch_headers pbh

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'
769: and not exists

Line 854: update pay_batch_headers

850: -- Change batch header status to 'unprocessed'
851: --
852: purge_rollback_messages(l_rec.batch_id,'H');
853: --
854: update pay_batch_headers
855: set batch_status = 'U'
856: where batch_id = l_rec.batch_id;
857: --
858: hr_utility.set_location('pay_mix_rollback_pkg.set_status',60);