[Home] [Help]
2554:
2555: /* SELECT region_2 primary_asg_state
2556: FROM HR_LOCATIONS loc,
2557: PER_ASSIGNMENTS_F asg,
2558: PER_BUSINESS_GROUPS bg
2559: -- Bug fix 1398865. Ensures one row is returned
2560: WHERE asg.assignment_number = p_assignment_number
2561: and asg.business_group_id = bg.business_group_id
2562: and bg.name ||'' = p_business_group_name
2570: 'N' , loc.region_2,
2571: addr.region_2) primary_asg_state
2572: FROM HR_LOCATIONS loc,
2573: PER_ASSIGNMENTS_F asg,
2574: PER_BUSINESS_GROUPS bg,
2575: PER_ADDRESSES addr
2576: -- Bug fix 1398865. Ensures one row is returned
2577: WHERE asg.assignment_number = p_assignment_number
2578: and asg.business_group_id = bg.business_group_id
2607: fed.ss_tax_exempt,
2608: nvl(fed.FED_INFORMATION2,'N')
2609: FROM pay_us_emp_fed_tax_rules_f fed,
2610: PER_ASSIGNMENTS_F a,
2611: PER_BUSINESS_GROUPS bg,
2612: pay_us_states pus
2613: WHERE fed.assignment_id = a.assignment_id
2614: and a.assignment_number = p_assignment_number
2615: and a.business_group_id = bg.business_group_id
2693: NVL(sta.STA_INFORMATION5,'N'),
2694: sta.sui_exempt
2695: FROM pay_us_emp_state_tax_rules_f sta,
2696: PER_ASSIGNMENTS_F a,
2697: PER_BUSINESS_GROUPS bg,
2698: pay_us_states pus
2699: WHERE sta.assignment_id = a.assignment_id
2700: and a.assignment_number = p_assignment_number
2701: and a.business_group_id = bg.business_group_id
2712: SELECT cnt.lit_exempt,
2713: NVL(cnt.sd_exempt,'N')
2714: FROM pay_us_emp_county_tax_rules_f cnt,
2715: PER_ASSIGNMENTS_F a,
2716: PER_BUSINESS_GROUPS bg,
2717: pay_us_states pus
2718: WHERE cnt.assignment_id = a.assignment_id
2719: and a.assignment_number = p_assignment_number
2720: and a.business_group_id = bg.business_group_id
2731: SELECT cty.lit_exempt,
2732: NVL(cty.sd_exempt,'N')
2733: FROM pay_us_emp_city_tax_rules_f cty,
2734: PER_ASSIGNMENTS_F a,
2735: PER_BUSINESS_GROUPS bg,
2736: pay_us_states pus
2737: WHERE cty.assignment_id = a.assignment_id
2738: and a.assignment_number = p_assignment_number
2739: and a.business_group_id = bg.business_group_id
2774: CURSOR c_get_wage_exempt IS
2775: SELECT wage_exempt
2776: FROM pay_us_emp_fed_tax_rules_f fed,
2777: per_assignments_f a,
2778: per_business_groups bg
2779: WHERE fed.assignment_id = a.assignment_id
2780: AND a.assignment_number = p_assignment_number
2781: AND a.business_group_id = bg.business_group_id
2782: AND bg.name ||'' = p_business_group_name
2884: a.payroll_id
2885: INTO l_assignment_id,
2886: l_bg_id,
2887: l_payroll_id
2888: FROM per_business_groups bg,
2889: per_assignments_f a,
2890: hr_soft_coding_keyflex hsk
2891: WHERE a.assignment_number = p_assignment_number
2892: and a.business_group_id = bg.business_group_id