[Home] [Help]
2553: CURSOR csr_sdi_check IS
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
2569: SELECT decode(nvl(asg.work_at_home, 'N'),
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
2606: fed.medicare_tax_exempt,
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
2692: sta.sdi_exempt,
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
2711: IS
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
2730: IS
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
2773:
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
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
2893: and bg.name ||'' = p_business_group_name
3395: l_asg_exists := 1;
3396:
3397: select count(0)
3398: into l_asg_exists
3399: from per_assignments_f
3400: where assignment_id = l_assignment_id
3401: and l_end_of_year_date between effective_start_date and effective_end_date;
3402: --
3403: -- if assignment doesn't exist ...
3409: -- get the termination date ...
3410: --
3411: select max(effective_end_date)
3412: into l_balance_fetch_date
3413: from per_assignments_f
3414: where assignment_id = l_assignment_id;
3415: ELSE
3416: l_balance_fetch_date := l_end_of_year_date;
3417: END IF;