DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_PKG dependencies on PAY_US_FEDERAL_TAX_INFO_F

Line 102: PAY_US_FEDERAL_TAX_INFO_F/

98: process_limits() to do limit
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

Line 136: pay_us_federal_tax_info_f.

132: 'D_DDMMYY','D_DDMMYYYY','D_MMDDYY','D_MMDDYYYY' do
133: not exist any more.
134: 115.9 22-NOV-1999 MHANDA Added fed_information_category = 401K
135: in the where clause for cursor for
136: pay_us_federal_tax_info_f.
137: 115.10 27-DEC-1999 tclewis modifed csr_chk_taxability to accept
138: jurisdiction code as a parameter. This
139: fixes a problem with checkin the taxability
140: rules for city and county records.

Line 564: FROM PAY_US_FEDERAL_TAX_INFO_F ftax

560: CURSOR csr_get_fed_wage_limits(v_effective_date DATE) IS
561: SELECT ftax.futa_wage_limit,
562: ftax.ss_ee_wage_limit,
563: ftax.ss_er_wage_limit
564: FROM PAY_US_FEDERAL_TAX_INFO_F ftax
565: WHERE v_effective_date BETWEEN ftax.effective_start_date
566: AND ftax.effective_end_date
567: AND ftax.fed_information_category = '401K LIMITS';
568: