APPS.PAY_US_TAX_BALS_ADJ_PKG dependencies on PAY_US_STATE_TAX_INFO_F

Line 103: PAY_US_STATE_TAX_INFO_F for federal

99: processing on limit based taxes
100: (eg. Medicare_EE/Medicare_ER). The limits
101: for taxes are fetched from the tables
102: PAY_US_FEDERAL_TAX_INFO_F/
103: PAY_US_STATE_TAX_INFO_F for federal
104: and state taxes respectively. Also
105: added the extra fields:
106: - futa_er
107: - sui_er

Line 577: PAY_US_STATE_TAX_INFO_F ti

573: ti.sdi_er_wage_limit,
574: ti.sui_ee_wage_limit,
575: ti.sui_er_wage_limit
576: FROM PAY_US_STATES st,
577: PAY_US_STATE_TAX_INFO_F ti
578: WHERE v_effective_date BETWEEN
579: ti.effective_start_date AND ti.effective_end_date
580: and st.state_code =
581: ti.state_code

Line 704: ** as used in PAY_US_STATE_TAX_INFO_F for NY

700: /*
701: ** Medicare EE and ER should have an infinite limit,
702: ** at a later stage a legislative limit may be defined,
703: ** therefore set to an arbitary value (99,999,999),
704: ** as used in PAY_US_STATE_TAX_INFO_F for NY
705: */
706: l_limit := 99999999;
707:
708: ELSIF (p_element_type = 'Medicare_ER') THEN

Line 1440: from pay_us_state_tax_info_f

1436: l_exists VARCHAR2(1) := 'N';
1437:
1438: cursor sdi_er_exists is
1439: select 'Y'
1440: from pay_us_state_tax_info_f
1441: where state_code = substr(p_jd_code, 1, 2)
1442: and sdi_er_wage_limit IS NOT NULL
1443: and p_adj_date between effective_start_date and effective_end_date;
1444:

Line 1447: from pay_us_state_tax_info_f

1443: and p_adj_date between effective_start_date and effective_end_date;
1444:
1445: cursor sdi_ee_exists is
1446: select 'Y'
1447: from pay_us_state_tax_info_f
1448: where state_code = substr(p_jd_code, 1, 2)
1449: and sdi_ee_wage_limit IS NOT NULL
1450: and p_adj_date between effective_start_date and effective_end_date;
1451:

Line 1454: from pay_us_state_tax_info_f

1450: and p_adj_date between effective_start_date and effective_end_date;
1451:
1452: cursor sui_er_exists is
1453: select 'Y'
1454: from pay_us_state_tax_info_f
1455: where state_code = substr(p_jd_code, 1, 2)
1456: and sui_er_wage_limit IS NOT NULL
1457: and p_adj_date between effective_start_date and effective_end_date;
1458:

Line 1461: from pay_us_state_tax_info_f

1457: and p_adj_date between effective_start_date and effective_end_date;
1458:
1459: cursor sui_ee_exists is
1460: select 'Y'
1461: from pay_us_state_tax_info_f
1462: where state_code = substr(p_jd_code, 1, 2)
1463: and sui_ee_wage_limit IS NOT NULL
1464: and p_adj_date between effective_start_date and effective_end_date;
1465:

Line 1468: from pay_us_state_tax_info_f

1464: and p_adj_date between effective_start_date and effective_end_date;
1465:
1466: cursor sit_exists is
1467: select sit_exists
1468: from pay_us_state_tax_info_f
1469: where state_code = substr(p_jd_code, 1, 2)
1470: and p_adj_date between effective_start_date and effective_end_date;
1471:
1472: cursor county_exists is