DBA Data[Home] [Help]

APPS.PAY_US_WEB_W4 dependencies on HR_SOFT_CODING_KEYFLEX

Line 1937: hr_soft_coding_keyflex hsck

1933: decode(ftr.futa_tax_exempt,'Y',1,0),
1934: decode(ftr.medicare_tax_exempt,'Y',1,0),
1935: decode(ftr.ss_tax_exempt,'Y',1,0)
1936: from pay_us_emp_fed_tax_rules_f ftr, per_assignments_f paf,
1937: hr_soft_coding_keyflex hsck
1938: where paf.person_id = ln_person_id
1939: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1940: and paf.assignment_id = ftr.assignment_id
1941: and paf.assignment_type = 'E'

Line 1962: ,hr_soft_coding_keyflex hsck

1958: decode(ftr.medicare_tax_exempt,'Y',1,0) medicare_tax_exempt_count,
1959: decode(ftr.ss_tax_exempt,'Y',1,0) ss_tax_exempt_count
1960: from pay_us_emp_fed_tax_rules_f ftr
1961: ,per_assignments_f paf
1962: ,hr_soft_coding_keyflex hsck
1963: where paf.person_id = ln_person_id
1964: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1965: and paf.assignment_id = ftr.assignment_id
1966: and paf.assignment_type = 'E'

Line 1999: hr_soft_coding_keyflex hsck

1995: ,decode(str.sdi_exempt,'Y',1,0)
1996: ,decode(str.wc_exempt,'Y',1,0)
1997: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
1998: pay_us_state_tax_info_f stif, pay_us_states pus,
1999: hr_soft_coding_keyflex hsck
2000: where paf.person_id = ln_person_id
2001: and paf.assignment_id = curvar_assignment_id
2002: and paf.assignment_id = str.assignment_id
2003: and paf.assignment_type = 'E'

Line 2033: hr_soft_coding_keyflex hsck

2029: ,decode(str.sdi_exempt,'Y',1,0) sdi_exempt_count
2030: ,decode(str.wc_exempt,'Y',1,0) wc_exempt_count
2031: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
2032: pay_us_state_tax_info_f stif, pay_us_states pus,
2033: hr_soft_coding_keyflex hsck
2034: where paf.person_id = ln_person_id
2035: and paf.assignment_id = curvar_assignment_id
2036: and paf.assignment_id = str.assignment_id
2037: and paf.assignment_type = 'E'

Line 2909: hr_soft_coding_keyflex hsck

2905: from pay_us_emp_state_tax_rules_f str,
2906: per_assignments_f paf,
2907: pay_us_state_tax_info_f stif,
2908: pay_us_states pus,
2909: hr_soft_coding_keyflex hsck
2910: where paf.person_id = p_person_id
2911: and paf.assignment_id = str.assignment_id
2912: and paf.assignment_type = 'E'
2913: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id