DBA Data[Home] [Help]

APPS.PAY_GENERIC_UPGRADE dependencies on PAY_FILE_DETAILS

Line 1034: DELETE FROM pay_file_details pfd

1030: where payroll_action_id = pactid
1031: and action_status <> 'C';
1032:
1033: if (l_remove_act is null or l_remove_act = 'Y') then
1034: DELETE FROM pay_file_details pfd
1035: WHERE EXISTS (SELECT 1
1036: FROM pay_temp_object_actions ptoa
1037: WHERE ptoa.object_action_id = pfd.source_id
1038: AND pfd.source_type = 'PAA') OR