[Home] [Help]
2036:
2037: CURSOR csr_sdi_check IS
2038: SELECT region_2 primary_asg_state
2039: FROM HR_LOCATIONS loc,
2040: PER_ASSIGNMENTS_F asg,
2041: PER_BUSINESS_GROUPS bg
2042: -- Bug fix 1398865. Ensures one row is returned
2043: WHERE asg.assignment_number = p_assignment_number
2044: and asg.business_group_id = bg.business_group_id
2067: fed.futa_tax_exempt,
2068: fed.medicare_tax_exempt,
2069: fed.ss_tax_exempt
2070: FROM pay_us_emp_fed_tax_rules_f fed,
2071: PER_ASSIGNMENTS_F a,
2072: PER_BUSINESS_GROUPS bg,
2073: pay_us_states pus
2074: WHERE fed.assignment_id = a.assignment_id
2075: and a.assignment_number = p_assignment_number
2141: SELECT sta.sit_exempt,
2142: sta.sdi_exempt,
2143: sta.sui_exempt
2144: FROM pay_us_emp_state_tax_rules_f sta,
2145: PER_ASSIGNMENTS_F a,
2146: PER_BUSINESS_GROUPS bg,
2147: pay_us_states pus
2148: WHERE sta.assignment_id = a.assignment_id
2149: and a.assignment_number = p_assignment_number
2160: IS
2161: SELECT cnt.lit_exempt,
2162: cnt.sd_exempt
2163: FROM pay_us_emp_county_tax_rules_f cnt,
2164: PER_ASSIGNMENTS_F a,
2165: PER_BUSINESS_GROUPS bg,
2166: pay_us_states pus
2167: WHERE cnt.assignment_id = a.assignment_id
2168: and a.assignment_number = p_assignment_number
2179: IS
2180: SELECT cty.lit_exempt,
2181: cty.sd_exempt
2182: FROM pay_us_emp_city_tax_rules_f cty,
2183: PER_ASSIGNMENTS_F a,
2184: PER_BUSINESS_GROUPS bg,
2185: pay_us_states pus
2186: WHERE cty.assignment_id = a.assignment_id
2187: and a.assignment_number = p_assignment_number
2243: INTO l_assignment_id,
2244: l_bg_id,
2245: l_payroll_id
2246: FROM per_business_groups bg,
2247: per_assignments_f a
2248: WHERE a.assignment_number = p_assignment_number
2249: and a.business_group_id = bg.business_group_id
2250: and bg.name ||'' = p_business_group_name
2251: and p_adjustment_date BETWEEN