DBA Data[Home] [Help]

APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 612: from pay_assignment_actions pac,

608: select pbh.batch_id,
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

Line 624: from pay_assignment_actions pac,

620: select ppa.batch_id,
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'

Line 822: pay_assignment_actions paa,

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