[Home] [Help]
8395: cursor recurring_entries is
8396: --
8397: select 'Y'
8398: from pay_run_results RESULT,
8399: pay_assignment_actions ASGT_ACTION,
8400: pay_payroll_actions PAY_ACTION,
8401: per_time_periods PERIOD
8402: where result.source_id = nvl (p_original_entry_id,
8403: p_element_entry_id)
8663: --
8664: -- Delete from both PAY_QUICKPAY_INCLUSIONS and PAY_QUICKPAY_EXCLUSIONS.
8665: --
8666: -- There is a chance the element entry id exists in both tables if
8667: -- any QuickPay assignment actions were created before the QuickPay
8668: -- Exclusions data model was in use.
8669: --
8670: delete from pay_quickpay_exclusions pqe
8671: where pqe.element_entry_id = p_element_entry_id
8670: delete from pay_quickpay_exclusions pqe
8671: where pqe.element_entry_id = p_element_entry_id
8672: and exists
8673: (select null
8674: from pay_assignment_actions paa,
8675: pay_payroll_actions ppa
8676: where paa.assignment_action_id = pqe.assignment_action_id
8677: and ppa.payroll_action_id = paa.payroll_action_id
8678: and ppa.date_earned between v_validation_start_date
8681: delete from pay_quickpay_inclusions pqi
8682: where pqi.element_entry_id = p_element_entry_id
8683: and exists
8684: (select null
8685: from pay_assignment_actions paa,
8686: pay_payroll_actions ppa
8687: where paa.assignment_action_id = pqi.assignment_action_id
8688: and ppa.payroll_action_id = paa.payroll_action_id
8689: and ppa.date_earned between v_validation_start_date