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_WEB_W4 dependencies on PAY_US_STATE_TAX_INFO_F

Line 743: select /+ INDEX (stif pay_us_state_tax_info_f_n1) / 'x'

739: -- bug 4707873 --or nvl(ftr.supp_tax_override_rate,0) <> 0
740: or nvl(ftr.fit_override_amount,0) <> 0);
741:
742: CURSOR c_excess_over_state IS
743: select /*+ INDEX (stif pay_us_state_tax_info_f_n1) */ 'x'
744: from per_assignments_f paf,
745: pay_us_emp_state_tax_rules_f str,
746: pay_us_state_tax_info_f stif
747: where paf.person_id = p_person_id

Line 746: pay_us_state_tax_info_f stif

742: CURSOR c_excess_over_state IS
743: select /*+ INDEX (stif pay_us_state_tax_info_f_n1) */ 'x'
744: from per_assignments_f paf,
745: pay_us_emp_state_tax_rules_f str,
746: pay_us_state_tax_info_f stif
747: where paf.person_id = p_person_id
748: and paf.assignment_type = 'E'
749: and str.assignment_id = paf.assignment_id
750: and stif.state_code = str.state_code

Line 777: select /+ INDEX (stif pay_us_state_tax_info_f_n1) / 'x'

773: and trunc(sysdate) between paf.effective_start_date and
774: paf.effective_end_date;
775:
776: CURSOR c_future_state_recs IS
777: select /*+ INDEX (stif pay_us_state_tax_info_f_n1) */ 'x'
778: from per_assignments_f paf,
779: pay_us_emp_state_tax_rules_f str,
780: pay_us_state_tax_info_f stif
781: where paf.person_id = p_person_id

Line 780: pay_us_state_tax_info_f stif

776: CURSOR c_future_state_recs IS
777: select /*+ INDEX (stif pay_us_state_tax_info_f_n1) */ 'x'
778: from per_assignments_f paf,
779: pay_us_emp_state_tax_rules_f str,
780: pay_us_state_tax_info_f stif
781: where paf.person_id = p_person_id
782: and str.assignment_id = paf.assignment_id
783: and paf.assignment_type = 'E'
784: and decode(l_primary_only,'Y',paf.primary_flag,'Y') = 'Y'

Line 1883: lv_state_exempt_code pay_us_state_tax_info_f.sta_information9%TYPE;

1879: cu_sui_wage_base_override_amt pay_us_emp_state_tax_rules_f.sui_wage_base_override_amount%TYPE;
1880: lv_state_name pay_us_states.state_name%TYPE;
1881: lv_state_code pay_us_states.state_code%TYPE;
1882: lv_state_default_code VARCHAR2(30);
1883: lv_state_exempt_code pay_us_state_tax_info_f.sta_information9%TYPE;
1884: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
1885: ln_dummy NUMBER(15);
1886: lb_comma_flag boolean := false;
1887: lv_datetrack_mode VARCHAR2(30);

Line 1998: pay_us_state_tax_info_f stif, pay_us_states pus,

1994: ,decode(str.sui_exempt,'Y',1,0)
1995: ,decode(str.sdi_exempt,'Y',1,0)
1996: ,decode(str.wc_exempt,'Y',1,0)
1997: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
1998: pay_us_state_tax_info_f stif, pay_us_states pus,
1999: hr_soft_coding_keyflex hsck
2000: where paf.person_id = ln_person_id
2001: and paf.assignment_id = curvar_assignment_id
2002: and paf.assignment_id = str.assignment_id

Line 2032: pay_us_state_tax_info_f stif, pay_us_states pus,

2028: ,decode(str.sui_exempt,'Y',1,0) sui_exempt_count
2029: ,decode(str.sdi_exempt,'Y',1,0) sdi_exempt_count
2030: ,decode(str.wc_exempt,'Y',1,0) wc_exempt_count
2031: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
2032: pay_us_state_tax_info_f stif, pay_us_states pus,
2033: hr_soft_coding_keyflex hsck
2034: where paf.person_id = ln_person_id
2035: and paf.assignment_id = curvar_assignment_id
2036: and paf.assignment_id = str.assignment_id

Line 2907: pay_us_state_tax_info_f stif,

2903: /*nvl(stif.sta_information9,'N') : Bug 6346579 */
2904: nvl(stif.sta_information9,'Y')
2905: from pay_us_emp_state_tax_rules_f str,
2906: per_assignments_f paf,
2907: pay_us_state_tax_info_f stif,
2908: pay_us_states pus,
2909: hr_soft_coding_keyflex hsck
2910: where paf.person_id = p_person_id
2911: and paf.assignment_id = str.assignment_id