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 614: pay_batch_headers pbh

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

Line 631: from pay_batch_headers pbh1

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

Line 649: from pay_batch_headers pbh

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

Line 735: pay_batch_headers pbh

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

Line 791: update pay_batch_headers

787: -- Change batch header status to 'unprocessed'
788: --
789: purge_rollback_messages(l_rec.batch_id,'H');
790: --
791: update pay_batch_headers
792: set batch_status = 'U'
793: where batch_id = l_rec.batch_id;
794: --
795: hr_utility.set_location('pay_mix_rollback_pkg.set_status',60);