DBA Data[Home] [Help]

APPS.HR_ENTRY_API dependencies on PAY_QUICKPAY_INCLUSIONS

Line 8720: -- Delete from both PAY_QUICKPAY_INCLUSIONS and PAY_QUICKPAY_EXCLUSIONS.

8716: end if;
8717: --
8718: -- Enhancement 3368211
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.

Line 8737: delete from pay_quickpay_inclusions pqi

8733: and ppa.payroll_action_id = paa.payroll_action_id
8734: and ppa.date_earned between v_validation_start_date
8735: and v_validation_end_date);
8736: --
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,