[Home] [Help]
253: delete from pay_gb_year_end_values v where exists (
254: select '1' from pay_gb_year_end_assignments ye_asg,
255: pay_payrolls_f p,
256: hr_soft_coding_keyflex flex,
257: hr_organization_information org
258: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
259: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
260: and org.org_information1 = flex.segment1
261: and p.business_group_id = p_business_group_id
280: -- delete all the rows for this tax_district_reference else if no
281: -- tax_district_reference specified delete all rows within the business group
282: delete from pay_gb_year_end_assignments ye_asg where exists (
283: select '1' from pay_payrolls_f p,
284: hr_soft_coding_keyflex flex, hr_organization_information org
285: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
286: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
287: and org.org_information1 = flex.segment1
288: and p.business_group_id = p_business_group_id
305: -- delete all the rows for this tax_district_reference else if no
306: -- tax_district_reference specified delete all rows within the business group
307: delete from pay_gb_year_end_payrolls ye_roll
308: where exists ( select '1' from pay_payrolls_f p,
309: hr_soft_coding_keyflex flex, hr_organization_information org
310: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
311: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
312: and org.org_information1 = flex.segment1
313: and p.business_group_id = p_business_group_id
833: flex.segment11 * 100 SMP_RECOVERED,
834: flex.segment12 * 100 SMP_COMPENSATION,
835: flex.segment13 * 100 SSP_RECOVERED
836: from pay_payrolls_f p,
837: hr_soft_coding_keyflex flex, hr_organization_information org
838: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
839: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
840: and org.org_information1 = flex.segment1
841: and p.business_group_id = p_business_group_id