APPS.PAY_US_WEB_W4 dependencies on HR_SOFT_CODING_KEYFLEX

Line 1796: hr_soft_coding_keyflex hsck

1792: decode(ftr.futa_tax_exempt,'Y',1,0),
1793: decode(ftr.medicare_tax_exempt,'Y',1,0),
1794: decode(ftr.ss_tax_exempt,'Y',1,0)
1795: from pay_us_emp_fed_tax_rules_f ftr, per_assignments_f paf,
1796: hr_soft_coding_keyflex hsck
1797: where paf.person_id = ln_person_id
1798: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1799: and paf.assignment_id = ftr.assignment_id
1800: and paf.assignment_type = 'E'

Line 1821: ,hr_soft_coding_keyflex hsck

1817: decode(ftr.medicare_tax_exempt,'Y',1,0) medicare_tax_exempt_count,
1818: decode(ftr.ss_tax_exempt,'Y',1,0) ss_tax_exempt_count
1819: from pay_us_emp_fed_tax_rules_f ftr
1820: ,per_assignments_f paf
1821: ,hr_soft_coding_keyflex hsck
1822: where paf.person_id = ln_person_id
1823: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1824: and paf.assignment_id = ftr.assignment_id
1825: and paf.assignment_type = 'E'

Line 1858: hr_soft_coding_keyflex hsck

1854: ,decode(str.sdi_exempt,'Y',1,0)
1855: ,decode(str.wc_exempt,'Y',1,0)
1856: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
1857: pay_us_state_tax_info_f stif, pay_us_states pus,
1858: hr_soft_coding_keyflex hsck
1859: where paf.person_id = ln_person_id
1860: and paf.assignment_id = curvar_assignment_id
1861: and paf.assignment_id = str.assignment_id
1862: and paf.assignment_type = 'E'

Line 1890: hr_soft_coding_keyflex hsck

1886: ,decode(str.sdi_exempt,'Y',1,0) sdi_exempt_count
1887: ,decode(str.wc_exempt,'Y',1,0) wc_exempt_count
1888: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
1889: pay_us_state_tax_info_f stif, pay_us_states pus,
1890: hr_soft_coding_keyflex hsck
1891: where paf.person_id = ln_person_id
1892: and paf.assignment_id = curvar_assignment_id
1893: and paf.assignment_id = str.assignment_id
1894: and paf.assignment_type = 'E'

Line 2737: hr_soft_coding_keyflex hsck

2733: from pay_us_emp_state_tax_rules_f str,
2734: per_assignments_f paf,
2735: pay_us_state_tax_info_f stif,
2736: pay_us_states pus,
2737: hr_soft_coding_keyflex hsck
2738: where paf.person_id = p_person_id
2739: and paf.assignment_id = str.assignment_id
2740: and paf.assignment_type = 'E'
2741: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id