DBA Data[Home] [Help]

APPS.PAY_PAYWSQEE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 589: v_pac_id pay_payroll_actions.payroll_action_id%TYPE;

585: p_wait varchar2 default 'N',
586: p_act_parameter_group_id number default null) return number is
587: --
588: v_request_id number := 0;
589: v_pac_id pay_payroll_actions.payroll_action_id%TYPE;
590: v_batch_status pay_batch_headers.batch_status%TYPE := null;
591: --
592: l_wait_outcome BOOLEAN;
593: l_phase VARCHAR2(80);

Line 605: from pay_payroll_actions pac

601: --
602:
603: cursor csr_pay_acts is
604: select pac.payroll_action_id
605: from pay_payroll_actions pac
606: where pac.action_type = 'BEE'
607: and pac.batch_id = p_batch_id
608: and pac.batch_process_mode = 'TRANSFER'
609: order by pac.payroll_action_id;