2247: -- code logic from hr_workflow_ss.check_mid_pay_period_change
2248:
2249: l_asg_txn_step_id:= get_assignment_step_id(p_transaction_id);
2250: l_effective_date := to_date(
2251: hr_transaction_ss.get_wf_effective_date
2252: (p_transaction_step_id => l_asg_txn_step_id),
2253: hr_transaction_ss.g_date_format);
2254:
2255: -- Get the pay_basis_id and payroll_id
2249: l_asg_txn_step_id:= get_assignment_step_id(p_transaction_id);
2250: l_effective_date := to_date(
2251: hr_transaction_ss.get_wf_effective_date
2252: (p_transaction_step_id => l_asg_txn_step_id),
2253: hr_transaction_ss.g_date_format);
2254:
2255: -- Get the pay_basis_id and payroll_id
2256: l_new_pay_basis_id := hr_transaction_api.get_number_value
2257: (p_transaction_step_id => l_asg_txn_step_id