DBA Data[Home] [Help]

APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 613: from pay_assignment_actions pac,

609: pac.assignment_id,
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

Line 626: from pay_assignment_actions pac,

622: pac.assignment_id,
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'

Line 885: pay_assignment_actions paa,

881:
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