800: where p_eff_date_csr > start_date
801: and p_eff_date_csr <= end_date
802: and payroll_id = p_payroll_id_csr;
803:
804: -- The following cursor is copied from hr_transaction_ss.process_transaction.
805: CURSOR csr_trs is
806: select trs.transaction_step_id
807: ,trs.api_name
808: ,trs.item_type
842: IF l_asg_txn_step_id IS NOT NULL
843: THEN
844:
845: l_effective_date := to_date(
846: hr_transaction_ss.get_wf_effective_date
847: (p_transaction_step_id => l_asg_txn_step_id),
848: hr_transaction_ss.g_date_format);
849:
850: -- Get the pay_basis_id and payroll_id
844:
845: l_effective_date := to_date(
846: hr_transaction_ss.get_wf_effective_date
847: (p_transaction_step_id => l_asg_txn_step_id),
848: hr_transaction_ss.g_date_format);
849:
850: -- Get the pay_basis_id and payroll_id
851: l_new_pay_basis_id := hr_transaction_api.get_number_value
852: (p_transaction_step_id => l_asg_txn_step_id