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.

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 1279: insert into PAY_US_EMP_STATE_TAX_RULES_F

1275:
1276: hr_utility.set_location('pay_us_emp_dt_tax_rules.ins_st_tax_row'||
1277: ' - inserting row', 4);
1278:
1279: insert into PAY_US_EMP_STATE_TAX_RULES_F
1280: (emp_state_tax_rule_id,
1281: effective_start_date,
1282: effective_end_date,
1283: assignment_id,

Line 2549: update PAY_US_EMP_STATE_TAX_RULES_F

2545:
2546: hr_utility.set_location('pay_us_emp_dt_tax_rules.ins_st_tax_row'||
2547: ' - updating row', 1);
2548:
2549: update PAY_US_EMP_STATE_TAX_RULES_F
2550: set emp_state_tax_rule_id = p_emp_state_tax_rule_id,
2551: effective_start_date = p_effective_start_date,
2552: effective_end_date = p_effective_end_date,
2553: assignment_id = p_assignment_id,

Line 3255: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */

3251: delete PAY_US_EMP_COUNTY_TAX_RULES_F
3252: where assignment_id = p_assignment_id
3253: and state_code = p_state_code;
3254:
3255: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */
3256:
3257: delete PAY_US_EMP_STATE_TAX_RULES_F
3258: where assignment_id = p_assignment_id
3259: and state_code = p_state_code;

Line 3257: delete PAY_US_EMP_STATE_TAX_RULES_F

3253: and state_code = p_state_code;
3254:
3255: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */
3256:
3257: delete PAY_US_EMP_STATE_TAX_RULES_F
3258: where assignment_id = p_assignment_id
3259: and state_code = p_state_code;
3260:
3261: elsif p_state_code is not null and p_county_code is not null

Line 3937: from PAY_US_EMP_STATE_TAX_RULES_F

3933: for update of assignment_id nowait;
3934:
3935: cursor csr_state_rec is
3936: select *
3937: from PAY_US_EMP_STATE_TAX_RULES_F
3938: where rowid = chartorowid(p_row_id)
3939: for update of emp_state_tax_rule_id nowait;
3940:
3941: state_rec csr_state_rec%rowtype;

Line 5512: from pay_us_emp_state_tax_rules_f pst

5508: cursor chk_state_exists is
5509: select 'Y'
5510: from dual
5511: where exists (select null
5512: from pay_us_emp_state_tax_rules_f pst
5513: where pst.assignment_id = p_assignment_id
5514: and state_code = p_state_code
5515: and business_group_id + 0 = p_business_group_id);
5516:

Line 6137: from pay_us_emp_state_tax_rules_f

6133:
6134: cursor c_all_states(p_assignment_id in number,
6135: p_session_date in date) is
6136: select state_code
6137: from pay_us_emp_state_tax_rules_f
6138: where assignment_id = p_assignment_id ;
6139:
6140: cursor c_tax_unit_id(p_assignment_id in number,
6141: p_session_date in date) is

Line 6418: update pay_us_emp_state_tax_rules_f

6414: END IF ;
6415: hr_utility.trace('l_sui_wg_base := '||to_char(l_sui_wg_base)) ;
6416:
6417: IF l_oth_combined_balance > 0 OR l_actual_balance_value > 0 THEN
6418: update pay_us_emp_state_tax_rules_f
6419: set sui_wage_base_override_amount = l_sui_wg_base
6420: where assignment_id = p_assignment_id
6421: and state_code = i_all_curr_states.state_code ;
6422: ELSE

Line 6423: update pay_us_emp_state_tax_rules_f

6419: set sui_wage_base_override_amount = l_sui_wg_base
6420: where assignment_id = p_assignment_id
6421: and state_code = i_all_curr_states.state_code ;
6422: ELSE
6423: update pay_us_emp_state_tax_rules_f
6424: set sui_wage_base_override_amount = null
6425: where assignment_id = p_assignment_id
6426: and state_code = i_all_curr_states.state_code ;
6427: END IF ;

Line 6485: update pay_us_emp_state_tax_rules_f

6481: hr_utility.trace('l_oth_combined_balance := '||to_char(l_oth_combined_balance)) ;
6482: hr_utility.trace('l_sui_wg_base := '||to_char(l_sui_wg_base)) ;
6483:
6484: IF l_oth_combined_balance > 0 OR l_combined_balance_value > 0 THEN
6485: update pay_us_emp_state_tax_rules_f
6486: set sui_wage_base_override_amount = l_sui_wg_base
6487: where assignment_id = p_assignment_id
6488: and state_code = state_code_tab(i) ;
6489: ELSE

Line 6490: update pay_us_emp_state_tax_rules_f

6486: set sui_wage_base_override_amount = l_sui_wg_base
6487: where assignment_id = p_assignment_id
6488: and state_code = state_code_tab(i) ;
6489: ELSE
6490: update pay_us_emp_state_tax_rules_f
6491: set sui_wage_base_override_amount = null
6492: where assignment_id = p_assignment_id
6493: and state_code = state_code_tab(i) ;
6494: END IF ;

Line 6505: update pay_us_emp_state_tax_rules_f

6501: open c_sui_wage_limit(p_state_code, l_max_asg_eff_st_dt) ;
6502: fetch c_sui_wage_limit into l_sui_er_wg_lt_curr_state ;
6503: close c_sui_wage_limit ;
6504:
6505: update pay_us_emp_state_tax_rules_f
6506: set sui_wage_base_override_amount = l_sui_er_wg_lt_curr_state
6507: where assignment_id = p_assignment_id
6508: and state_code = p_state_code ;
6509: END IF ;

Line 7224: from PAY_US_EMP_STATE_TAX_RULES_F str

7220: l_jurisdiction_code varchar2(11);
7221:
7222: cursor csr_get_states is
7223: select state_code
7224: from PAY_US_EMP_STATE_TAX_RULES_F str
7225: where str.assignment_id = p_assignment_id
7226: and p_session_date between str.effective_start_date
7227: and str.effective_end_date;
7228:

Line 7532: from PAY_US_EMP_STATE_TAX_RULES_F str

7528: l_jurisdiction_code varchar2(11);
7529:
7530: cursor csr_get_states is
7531: select state_code
7532: from PAY_US_EMP_STATE_TAX_RULES_F str
7533: where str.assignment_id = p_assignment_id
7534: and p_session_date between
7535: str.effective_start_date and str.effective_end_date;
7536:

Line 10493: update PAY_US_EMP_STATE_TAX_RULES_F

10489: fnd_message.set_token('STEP','2');
10490: fnd_message.raise_error;
10491: end if;
10492:
10493: update PAY_US_EMP_STATE_TAX_RULES_F
10494: set effective_start_date = p_new_start_date
10495: where assignment_id = p_assignment_id
10496: and l_ef_date between effective_start_date and effective_end_date;
10497:

Line 10536: delete PAY_US_EMP_STATE_TAX_RULES_F

10532: delete PAY_US_EMP_FED_TAX_RULES_F
10533: where assignment_id = p_assignment_id
10534: and p_new_start_date > effective_start_date;
10535:
10536: delete PAY_US_EMP_STATE_TAX_RULES_F
10537: where assignment_id = p_assignment_id
10538: and p_new_start_date > effective_start_date;
10539:
10540: delete PAY_US_EMP_COUNTY_TAX_RULES_F

Line 11997: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */

11993: delete PAY_US_EMP_COUNTY_TAX_RULES_F
11994: where assignment_id = p_assignment_id
11995: and business_group_id = p_business_group_id;
11996:
11997: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */
11998:
11999: delete PAY_US_EMP_STATE_TAX_RULES_F
12000: where assignment_id = p_assignment_id
12001: and business_group_id = p_business_group_id;

Line 11999: delete PAY_US_EMP_STATE_TAX_RULES_F

11995: and business_group_id = p_business_group_id;
11996:
11997: /* Delete records from PAY_US_EMP_STATE_TAX_RULES_F */
11998:
11999: delete PAY_US_EMP_STATE_TAX_RULES_F
12000: where assignment_id = p_assignment_id
12001: and business_group_id = p_business_group_id;
12002:
12003: /* Delete records from PAY_US_EMP_FED_TAX_RULES_F */