APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_EMP_DT_TAX_VAL

Line 1648: pay_us_emp_dt_tax_val.check_school_district(

1644:
1645: /* Check that the school district is assigned to only one county/city
1646: at a given point in time */
1647:
1648: pay_us_emp_dt_tax_val.check_school_district(
1649: p_assignment => p_assignment_id,
1650: p_start_date => p_effective_start_date,
1651: p_end_date => p_effective_end_date,
1652: p_mode => 'I',

Line 2033: pay_us_emp_dt_tax_val.check_school_district(

2029:
2030: /* Check that the school district is assigned to only one county/city
2031: at a given point in time */
2032:
2033: pay_us_emp_dt_tax_val.check_school_district(
2034: p_assignment => p_assignment_id,
2035: p_start_date => p_effective_start_date,
2036: p_end_date => p_effective_end_date,
2037: p_mode => 'I',

Line 2824: pay_us_emp_dt_tax_val.check_school_district(

2820: ' - checking sd', 1);
2821: /* Check that the school district is assigned to only one county/city
2822: at a given point in time */
2823:
2824: pay_us_emp_dt_tax_val.check_school_district(
2825: p_assignment => p_assignment_id,
2826: p_start_date => p_effective_start_date,
2827: p_end_date => p_effective_end_date,
2828: p_mode => 'U',

Line 3042: pay_us_emp_dt_tax_val.check_school_district(

3038:
3039: /* Check that the school district is assigned to only one county/city
3040: at a given point in time */
3041:
3042: pay_us_emp_dt_tax_val.check_school_district(
3043: p_assignment => p_assignment_id,
3044: p_start_date => p_effective_start_date,
3045: p_end_date => p_effective_end_date,
3046: p_mode => 'U',

Line 6744: pay_us_emp_dt_tax_val.check_jurisdiction_exists(p_assignment_id => p_assignment_id,

6740: l_ret_text := null;
6741: l_jurisdiction_code := l_state_code ||'-000-0000';
6742:
6743: hr_utility.set_location('pay_us_emp_dt_tax_rules.create_new_location_rec',5);
6744: pay_us_emp_dt_tax_val.check_jurisdiction_exists(p_assignment_id => p_assignment_id,
6745: p_jurisdiction_code => l_jurisdiction_code,
6746: p_ret_code => l_ret_code,
6747: p_ret_text => l_ret_text);
6748: hr_utility.set_location('pay_us_emp_dt_tax_rules.create_new_location_rec',6);

Line 6851: pay_us_emp_dt_tax_val.check_jurisdiction_exists(p_assignment_id => p_assignment_id,

6847: l_ret_text := null;
6848: l_jurisdiction_code := l_state_code ||'-' || l_county_code ||'-0000';
6849:
6850: hr_utility.set_location('pay_us_emp_dt_tax_rules.create_new_location_rec',11);
6851: pay_us_emp_dt_tax_val.check_jurisdiction_exists(p_assignment_id => p_assignment_id,
6852: p_jurisdiction_code => l_jurisdiction_code,
6853: p_ret_code => l_ret_code,
6854: p_ret_text => l_ret_text);
6855: hr_utility.set_location('pay_us_emp_dt_tax_rules.create_new_location_rec',12);

Line 6904: pay_us_emp_dt_tax_val.check_jurisdiction_exists(p_assignment_id => p_assignment_id,

6900: l_jurisdiction_code := l_state_code ||'-' || l_county_code ||'-'||
6901: l_city_code;
6902:
6903: hr_utility.set_location('pay_us_emp_dt_tax_rules.create_new_location_rec',16);
6904: pay_us_emp_dt_tax_val.check_jurisdiction_exists(p_assignment_id => p_assignment_id,
6905: p_jurisdiction_code => l_jurisdiction_code,
6906: p_ret_code => l_ret_code,
6907: p_ret_text => l_ret_text);
6908: hr_utility.set_location('pay_us_emp_dt_tax_rules.create_new_location_rec',17);

Line 10784: pay_us_emp_dt_tax_val.get_orig_res_codes (p_assignment_id => p_assignment_id,

10780:
10781: /* Get the resident and the work state, county and city codes */
10782:
10783: hr_utility.set_location('pay_us_emp_dt_tax_rules.default_tax',1);
10784: pay_us_emp_dt_tax_val.get_orig_res_codes (p_assignment_id => p_assignment_id,
10785:
10786: p_session_date => p_effective_start_date,
10787: p_res_state_code => l_res_state_code,
10788: p_res_county_code => l_res_county_code,

Line 10828: pay_us_emp_dt_tax_val.get_all_work_codes (p_assignment_id => p_assignment_id,

10824: end if;
10825: close csr_chk_addr_ovrd;
10826:
10827: hr_utility.set_location('pay_us_emp_dt_tax_rules.default_tax',4);
10828: pay_us_emp_dt_tax_val.get_all_work_codes (p_assignment_id => p_assignment_id,
10829: p_session_date => p_effective_start_date,
10830: p_work_state_code => l_work_state_code,
10831: p_work_county_code => l_work_county_code,
10832: p_work_city_code => l_work_city_code,

Line 11152: if pay_us_emp_dt_tax_val.check_locations(p_assignment_id => p_assignment_id,

11148: and p_from_form in ('Assignment', 'Tax Rules','Address') then
11149: /* Check to see if future dated change in locations has taken
11150: place or not */
11151:
11152: if pay_us_emp_dt_tax_val.check_locations(p_assignment_id => p_assignment_id,
11153: p_effective_start_date => p_effective_start_date,
11154: p_business_group_id => p_business_group_id)
11155: then
11156:

Line 11569: pay_us_emp_dt_tax_val.get_orig_res_codes (p_assignment_id => l_assignment_id,

11565: records.
11566: Get the state code, county code and the city code for the resident
11567: address */
11568:
11569: pay_us_emp_dt_tax_val.get_orig_res_codes (p_assignment_id => l_assignment_id,
11570: p_session_date => p_effective_start_date,
11571: p_res_state_code => l_res_state_code,
11572: p_res_county_code => l_res_county_code,
11573: p_res_city_code => l_res_city_code,

Line 12056: not pay_us_emp_dt_tax_val.check_locations(p_assignment_id => p_assignment_id,

12052: close csr_get_end_date;
12053:
12054:
12055: if (l_end_date = to_date('31-12-4712','dd-mm-yyyy')) and
12056: not pay_us_emp_dt_tax_val.check_locations(p_assignment_id => p_assignment_id,
12057: p_effective_start_date => p_session_date,
12058: p_business_group_id => p_business_group_id)
12059: then
12060: