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_STATES

Line 254: p_state_code IN pay_us_states.state_code%TYPE

250: -- NOT be copied and an Informational Message will be displayed to Customer.
251: --
252:
253: FUNCTION Fed_State_Filing_Status_Match(
254: p_state_code IN pay_us_states.state_code%TYPE
255: ,p_state_org_filing_status_code IN pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
256: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
257: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
258: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE

Line 267: FROM pay_us_states

263: RETURN BOOLEAN IS
264:
265: CURSOR cur_state_name(p_st_cd IN VARCHAR2) IS
266: SELECT state_name
267: FROM pay_us_states
268: WHERE state_code = p_st_cd;
269:
270: CURSOR cur_filing_status_meaning(p_state_code VARCHAR2
271: ,p_filing_status_code VARCHAR2) IS

Line 279: lv_state_name pay_us_states.state_name%TYPE;

275: AND lpad(lookup_code,2,'0') = p_filing_status_code
276: AND application_id = 800
277: AND enabled_flag = 'Y';
278:
279: lv_state_name pay_us_states.state_name%TYPE;
280: lv_fed_03_meaning hr_lookups.meaning%TYPE;
281: lv_state_fs_meaning hr_lookups.meaning%TYPE;
282: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;
283:

Line 1010: lv_notmatch_state pay_us_states.state_name%TYPE;

1006: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
1007:
1008: ln_prev_comma_position NUMBER;
1009: ln_comma_position NUMBER;
1010: lv_notmatch_state pay_us_states.state_name%TYPE;
1011:
1012:
1013: BEGIN
1014:

Line 1762: lv_state_name pay_us_states.state_name%TYPE;

1758: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1759: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1760: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1761: lv_last_name_diff_flag VARCHAR2(1);
1762: lv_state_name pay_us_states.state_name%TYPE;
1763: lv_state_code pay_us_states.state_code%TYPE;
1764: lv_state_default_code VARCHAR2(30);
1765: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
1766: ln_dummy NUMBER(15);

Line 1763: lv_state_code pay_us_states.state_code%TYPE;

1759: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1760: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1761: lv_last_name_diff_flag VARCHAR2(1);
1762: lv_state_name pay_us_states.state_name%TYPE;
1763: lv_state_code pay_us_states.state_code%TYPE;
1764: lv_state_default_code VARCHAR2(30);
1765: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
1766: ln_dummy NUMBER(15);
1767: lb_comma_flag boolean := false;

Line 1880: lv_state_name pay_us_states.state_name%TYPE;

1876: cu_sit_exempt pay_us_emp_state_tax_rules_f.sit_exempt%TYPE;
1877: ln_state_addtional_tax pay_us_emp_state_tax_rules_f.sit_additional_tax%TYPE;
1878:
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;

Line 1881: lv_state_code pay_us_states.state_code%TYPE;

1877: ln_state_addtional_tax pay_us_emp_state_tax_rules_f.sit_additional_tax%TYPE;
1878:
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);

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 2908: pay_us_states pus,

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
2912: and paf.assignment_type = 'E'