eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_EMP_STATE_TAX_RULES_F

Line 1252: from PAY_US_EMP_STATE_TAX_RULES_F str

1248: from sys.DUAL;
1249:
1250: cursor csr_get_row_id is
1251: select rowidtochar(rowid)
1252: from PAY_US_EMP_STATE_TAX_RULES_F str
1253: where str.emp_state_tax_rule_id = p_emp_state_tax_rule_id
1254: and str.effective_start_date = p_effective_start_date
1255: and str.effective_end_date = p_effective_end_date;
1256:

Line 1260: from pay_us_emp_state_tax_rules_f sta

1256:
1257: -- Added for bug 13872151
1258: cursor csr_state_tax_rule is
1259: select null
1260: from pay_us_emp_state_tax_rules_f sta
1261: where sta.assignment_id = p_assignment_id
1262: and sta.state_code = p_state_code;
1263:
1264: l_dummy VARCHAR2(5);

Line 1303: insert into PAY_US_EMP_STATE_TAX_RULES_F

1299: end if;
1300: close csr_state_tax_rule;
1301: --End of changes for bug 13872151
1302:
1303: insert into PAY_US_EMP_STATE_TAX_RULES_F
1304: (emp_state_tax_rule_id,
1305: effective_start_date,
1306: effective_end_date,
1307: assignment_id,

Line 2624: update PAY_US_EMP_STATE_TAX_RULES_F

2620:
2621: hr_utility.set_location('pay_us_emp_dt_tax_rules.ins_st_tax_row'||
2622: ' - updating row', 1);
2623:
2624: update PAY_US_EMP_STATE_TAX_RULES_F
2625: set emp_state_tax_rule_id = p_emp_state_tax_rule_id,
2626: effective_start_date = p_effective_start_date,
2627: effective_end_date = p_effective_end_date,
2628: assignment_id = p_assignment_id,

Line 3331: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */

3327: delete PAY_US_EMP_COUNTY_TAX_RULES_F
3328: where assignment_id = p_assignment_id
3329: and state_code = p_state_code;
3330:
3331: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */
3332:
3333: delete PAY_US_EMP_STATE_TAX_RULES_F
3334: where assignment_id = p_assignment_id
3335: and state_code = p_state_code;

Line 3333: delete PAY_US_EMP_STATE_TAX_RULES_F

3329: and state_code = p_state_code;
3330:
3331: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */
3332:
3333: delete PAY_US_EMP_STATE_TAX_RULES_F
3334: where assignment_id = p_assignment_id
3335: and state_code = p_state_code;
3336:
3337: elsif p_state_code is not null and p_county_code is not null

Line 4013: from PAY_US_EMP_STATE_TAX_RULES_F

4009: for update of assignment_id nowait;
4010:
4011: cursor csr_state_rec is
4012: select *
4013: from PAY_US_EMP_STATE_TAX_RULES_F
4014: where rowid = chartorowid(p_row_id)
4015: for update of emp_state_tax_rule_id nowait;
4016:
4017: state_rec csr_state_rec%rowtype;

Line 5588: from pay_us_emp_state_tax_rules_f pst

5584: cursor chk_state_exists is
5585: select 'Y'
5586: from dual
5587: where exists (select null
5588: from pay_us_emp_state_tax_rules_f pst
5589: where pst.assignment_id = p_assignment_id
5590: and state_code = p_state_code
5591: and business_group_id + 0 = p_business_group_id);
5592:

Line 6213: from pay_us_emp_state_tax_rules_f

6209:
6210: cursor c_all_states(p_assignment_id in number,
6211: p_session_date in date) is
6212: select state_code
6213: from pay_us_emp_state_tax_rules_f
6214: where assignment_id = p_assignment_id ;
6215:
6216: cursor c_tax_unit_id(p_assignment_id in number,
6217: p_session_date in date) is

Line 6494: update pay_us_emp_state_tax_rules_f

6490: END IF ;
6491: hr_utility.trace('l_sui_wg_base := '||to_char(l_sui_wg_base)) ;
6492:
6493: IF l_oth_combined_balance > 0 OR l_actual_balance_value > 0 THEN
6494: update pay_us_emp_state_tax_rules_f
6495: set sui_wage_base_override_amount = l_sui_wg_base
6496: where assignment_id = p_assignment_id
6497: and state_code = i_all_curr_states.state_code ;
6498: ELSE

Line 6499: update pay_us_emp_state_tax_rules_f

6495: set sui_wage_base_override_amount = l_sui_wg_base
6496: where assignment_id = p_assignment_id
6497: and state_code = i_all_curr_states.state_code ;
6498: ELSE
6499: update pay_us_emp_state_tax_rules_f
6500: set sui_wage_base_override_amount = null
6501: where assignment_id = p_assignment_id
6502: and state_code = i_all_curr_states.state_code ;
6503: END IF ;

Line 6561: update pay_us_emp_state_tax_rules_f

6557: hr_utility.trace('l_oth_combined_balance := '||to_char(l_oth_combined_balance)) ;
6558: hr_utility.trace('l_sui_wg_base := '||to_char(l_sui_wg_base)) ;
6559:
6560: IF l_oth_combined_balance > 0 OR l_combined_balance_value > 0 THEN
6561: update pay_us_emp_state_tax_rules_f
6562: set sui_wage_base_override_amount = l_sui_wg_base
6563: where assignment_id = p_assignment_id
6564: and state_code = state_code_tab(i) ;
6565: ELSE

Line 6566: update pay_us_emp_state_tax_rules_f

6562: set sui_wage_base_override_amount = l_sui_wg_base
6563: where assignment_id = p_assignment_id
6564: and state_code = state_code_tab(i) ;
6565: ELSE
6566: update pay_us_emp_state_tax_rules_f
6567: set sui_wage_base_override_amount = null
6568: where assignment_id = p_assignment_id
6569: and state_code = state_code_tab(i) ;
6570: END IF ;

Line 6581: update pay_us_emp_state_tax_rules_f

6577: open c_sui_wage_limit(p_state_code, l_max_asg_eff_st_dt) ;
6578: fetch c_sui_wage_limit into l_sui_er_wg_lt_curr_state ;
6579: close c_sui_wage_limit ;
6580:
6581: update pay_us_emp_state_tax_rules_f
6582: set sui_wage_base_override_amount = l_sui_er_wg_lt_curr_state
6583: where assignment_id = p_assignment_id
6584: and state_code = p_state_code ;
6585: END IF ;

Line 7300: from PAY_US_EMP_STATE_TAX_RULES_F str

7296: l_jurisdiction_code varchar2(11);
7297:
7298: cursor csr_get_states is
7299: select state_code
7300: from PAY_US_EMP_STATE_TAX_RULES_F str
7301: where str.assignment_id = p_assignment_id
7302: and p_session_date between str.effective_start_date
7303: and str.effective_end_date;
7304:

Line 7608: from PAY_US_EMP_STATE_TAX_RULES_F str

7604: l_jurisdiction_code varchar2(11);
7605:
7606: cursor csr_get_states is
7607: select state_code
7608: from PAY_US_EMP_STATE_TAX_RULES_F str
7609: where str.assignment_id = p_assignment_id
7610: and p_session_date between
7611: str.effective_start_date and str.effective_end_date;
7612:

Line 10569: update PAY_US_EMP_STATE_TAX_RULES_F

10565: fnd_message.set_token('STEP','2');
10566: fnd_message.raise_error;
10567: end if;
10568:
10569: update PAY_US_EMP_STATE_TAX_RULES_F
10570: set effective_start_date = p_new_start_date
10571: where assignment_id = p_assignment_id
10572: and l_ef_date between effective_start_date and effective_end_date;
10573:

Line 10612: delete PAY_US_EMP_STATE_TAX_RULES_F

10608: delete PAY_US_EMP_FED_TAX_RULES_F
10609: where assignment_id = p_assignment_id
10610: and p_new_start_date > effective_start_date;
10611:
10612: delete PAY_US_EMP_STATE_TAX_RULES_F
10613: where assignment_id = p_assignment_id
10614: and p_new_start_date > effective_start_date;
10615:
10616: delete PAY_US_EMP_COUNTY_TAX_RULES_F

Line 12073: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */

12069: delete PAY_US_EMP_COUNTY_TAX_RULES_F
12070: where assignment_id = p_assignment_id
12071: and business_group_id = p_business_group_id;
12072:
12073: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */
12074:
12075: delete PAY_US_EMP_STATE_TAX_RULES_F
12076: where assignment_id = p_assignment_id
12077: and business_group_id = p_business_group_id;

Line 12075: delete PAY_US_EMP_STATE_TAX_RULES_F

12071: and business_group_id = p_business_group_id;
12072:
12073: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */
12074:
12075: delete PAY_US_EMP_STATE_TAX_RULES_F
12076: where assignment_id = p_assignment_id
12077: and business_group_id = p_business_group_id;
12078:
12079: /* Delete records from PAY_US_EMP_FED_TAX_RULES_F */