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 216: p_state_code IN pay_us_states.state_code%TYPE

212: -- NOT be copied and an Informational Message will be displayed to Customer.
213: --
214:
215: FUNCTION Fed_State_Filing_Status_Match(
216: p_state_code IN pay_us_states.state_code%TYPE
217: ,p_state_org_filing_status_code IN pay_us_emp_state_tax_rules_f.filing_status_code%TYPE
218: ,p_fed_org_filing_status_code IN pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE
219: ,p_fed_org_wa IN pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE
220: ,p_state_org_wa IN pay_us_emp_state_tax_rules_f.withholding_allowances%TYPE

Line 229: FROM pay_us_states

225: RETURN BOOLEAN IS
226:
227: CURSOR cur_state_name(p_st_cd IN VARCHAR2) IS
228: SELECT state_name
229: FROM pay_us_states
230: WHERE state_code = p_st_cd;
231:
232: CURSOR cur_filing_status_meaning(p_state_code VARCHAR2
233: ,p_filing_status_code VARCHAR2) IS

Line 241: lv_state_name pay_us_states.state_name%TYPE;

237: AND lpad(lookup_code,2,'0') = p_filing_status_code
238: AND application_id = 800
239: AND enabled_flag = 'Y';
240:
241: lv_state_name pay_us_states.state_name%TYPE;
242: lv_fed_03_meaning hr_lookups.meaning%TYPE;
243: lv_state_fs_meaning hr_lookups.meaning%TYPE;
244: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;
245:

Line 878: lv_notmatch_state pay_us_states.state_name%TYPE;

874: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
875:
876: ln_prev_comma_position NUMBER;
877: ln_comma_position NUMBER;
878: lv_notmatch_state pay_us_states.state_name%TYPE;
879:
880:
881: BEGIN
882:

Line 1621: lv_state_name pay_us_states.state_name%TYPE;

1617: lv_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
1618: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1619: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1620: lv_last_name_diff_flag VARCHAR2(1);
1621: lv_state_name pay_us_states.state_name%TYPE;
1622: lv_state_code pay_us_states.state_code%TYPE;
1623: lv_state_default_code VARCHAR2(30);
1624: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
1625: ln_dummy NUMBER(15);

Line 1622: lv_state_code pay_us_states.state_code%TYPE;

1618: lv_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1619: lv_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
1620: lv_last_name_diff_flag VARCHAR2(1);
1621: lv_state_name pay_us_states.state_name%TYPE;
1622: lv_state_code pay_us_states.state_code%TYPE;
1623: lv_state_default_code VARCHAR2(30);
1624: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
1625: ln_dummy NUMBER(15);
1626: lb_comma_flag boolean := false;

Line 1739: lv_state_name pay_us_states.state_name%TYPE;

1735: cu_sit_exempt pay_us_emp_state_tax_rules_f.sit_exempt%TYPE;
1736: ln_state_addtional_tax pay_us_emp_state_tax_rules_f.sit_additional_tax%TYPE;
1737:
1738: cu_sui_wage_base_override_amt pay_us_emp_state_tax_rules_f.sui_wage_base_override_amount%TYPE;
1739: lv_state_name pay_us_states.state_name%TYPE;
1740: lv_state_code pay_us_states.state_code%TYPE;
1741: lv_state_default_code VARCHAR2(30);
1742: lv_state_exempt_code pay_us_state_tax_info_f.sta_information9%TYPE;
1743: lv_context pay_stat_trans_audit.audit_information_category%TYPE;

Line 1740: lv_state_code pay_us_states.state_code%TYPE;

1736: ln_state_addtional_tax pay_us_emp_state_tax_rules_f.sit_additional_tax%TYPE;
1737:
1738: cu_sui_wage_base_override_amt pay_us_emp_state_tax_rules_f.sui_wage_base_override_amount%TYPE;
1739: lv_state_name pay_us_states.state_name%TYPE;
1740: lv_state_code pay_us_states.state_code%TYPE;
1741: lv_state_default_code VARCHAR2(30);
1742: lv_state_exempt_code pay_us_state_tax_info_f.sta_information9%TYPE;
1743: lv_context pay_stat_trans_audit.audit_information_category%TYPE;
1744: ln_dummy NUMBER(15);

Line 1857: pay_us_state_tax_info_f stif, pay_us_states pus,

1853: ,decode(str.sui_exempt,'Y',1,0)
1854: ,decode(str.sdi_exempt,'Y',1,0)
1855: ,decode(str.wc_exempt,'Y',1,0)
1856: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
1857: pay_us_state_tax_info_f stif, pay_us_states pus,
1858: hr_soft_coding_keyflex hsck
1859: where paf.person_id = ln_person_id
1860: and paf.assignment_id = curvar_assignment_id
1861: and paf.assignment_id = str.assignment_id

Line 1889: pay_us_state_tax_info_f stif, pay_us_states pus,

1885: ,decode(str.sui_exempt,'Y',1,0) sui_exempt_count
1886: ,decode(str.sdi_exempt,'Y',1,0) sdi_exempt_count
1887: ,decode(str.wc_exempt,'Y',1,0) wc_exempt_count
1888: from pay_us_emp_state_tax_rules_f str, per_assignments_f paf,
1889: pay_us_state_tax_info_f stif, pay_us_states pus,
1890: hr_soft_coding_keyflex hsck
1891: where paf.person_id = ln_person_id
1892: and paf.assignment_id = curvar_assignment_id
1893: and paf.assignment_id = str.assignment_id

Line 2736: pay_us_states pus,

2732: nvl(stif.sta_information9,'N')
2733: from pay_us_emp_state_tax_rules_f str,
2734: per_assignments_f paf,
2735: pay_us_state_tax_info_f stif,
2736: pay_us_states pus,
2737: hr_soft_coding_keyflex hsck
2738: where paf.person_id = p_person_id
2739: and paf.assignment_id = str.assignment_id
2740: and paf.assignment_type = 'E'