[Home] [Help]
8412: cursor recurring_entries is
8413: --
8414: select 'Y'
8415: from pay_run_results RESULT,
8416: pay_assignment_actions ASGT_ACTION,
8417: pay_payroll_actions PAY_ACTION,
8418: per_time_periods PERIOD
8419: where result.source_id = nvl (p_original_entry_id,
8420: p_element_entry_id)
8719: --
8720: -- Delete from both PAY_QUICKPAY_INCLUSIONS and PAY_QUICKPAY_EXCLUSIONS.
8721: --
8722: -- There is a chance the element entry id exists in both tables if
8723: -- any QuickPay assignment actions were created before the QuickPay
8724: -- Exclusions data model was in use.
8725: --
8726: delete from pay_quickpay_exclusions pqe
8727: where pqe.element_entry_id = p_element_entry_id
8726: delete from pay_quickpay_exclusions pqe
8727: where pqe.element_entry_id = p_element_entry_id
8728: and exists
8729: (select null
8730: from pay_assignment_actions paa,
8731: pay_payroll_actions ppa
8732: where paa.assignment_action_id = pqe.assignment_action_id
8733: and ppa.payroll_action_id = paa.payroll_action_id
8734: and ppa.date_earned between v_validation_start_date
8737: delete from pay_quickpay_inclusions pqi
8738: where pqi.element_entry_id = p_element_entry_id
8739: and exists
8740: (select null
8741: from pay_assignment_actions paa,
8742: pay_payroll_actions ppa
8743: where paa.assignment_action_id = pqi.assignment_action_id
8744: and ppa.payroll_action_id = paa.payroll_action_id
8745: and ppa.date_earned between v_validation_start_date