APPS.PAYUSUNB_PKG dependencies on PAY_US_FEDERAL_TAX_INFO_F

Line 132: from pay_us_federal_tax_info_f table

128: to return -1 if there is no override FUTA Credit
129: rate in "State Tax Rules" Flexfiled.
130: Modified prc_federal_balances procedure
131: to take the Net FUTA Rate directly
132: from pay_us_federal_tax_info_f table
133: in case override credit limit is not set.
134: otherwise it will take Gross Rate from
135: FED_INFORMATION11 to calculate net futa rate.
136: 21-Sep-2011 emunisek 12742758 115.40 Created function get_calculated_fed_limit_tax to calculate

Line 279: FROM pay_us_federal_tax_info_f

275: WHERE payroll_action_id = IN_pact_id;
276:
277: CURSOR c_get_futa_rate(p_as_of_date DATE) IS
278: SELECT futa_rate
279: FROM pay_us_federal_tax_info_f
280: WHERE p_as_of_date
281: BETWEEN effective_start_date
282: AND effective_end_date
283: AND fed_information_category='401K LIMITS'

Line 288: FROM pay_us_federal_tax_info_f

284: ORDER BY effective_start_date;
285:
286: CURSOR c_futa_count_changes(p_as_of_date DATE,p_dimension VARCHAR2) IS
287: SELECT count(distinct futa_rate)
288: FROM pay_us_federal_tax_info_f
289: WHERE effective_start_date <= p_as_of_date
290: AND effective_end_date >= TRUNC(p_as_of_date,decode(p_dimension,'QTD','Q','YTD','Y'))
291: AND fed_information_category='401K LIMITS';
292:

Line 1058: FROM pay_us_federal_tax_info_f

1054: ss_ee_rate,
1055: ss_er_rate,
1056: medi_ee_rate,
1057: medi_er_rate
1058: FROM pay_us_federal_tax_info_f
1059: WHERE effective_start_date <= p_as_of_date
1060: AND effective_end_date >= TRUNC(p_as_of_date,decode(p_dimension,'QTD','Q','YTD','Y'))
1061: AND fed_information_category='401K LIMITS'
1062: ORDER BY effective_start_date;

Line 2749: FROM pay_us_federal_tax_info_f

2745: BEGIN /* Get new Medicare Limit and Rate, Subtract 0.01 from Limit as the actual value is the starting value of limit */
2746: SELECT TO_NUMBER(fed_attribute1) - 0.01, /* Bug#15852506 */
2747: fed_attribute2
2748: INTO L_medi_ee_lmt1, L_medi_ee_rate1
2749: FROM pay_us_federal_tax_info_f
2750: WHERE fed_information_category = '401K LIMITS'
2751: AND L_as_of_date BETWEEN effective_start_date AND effective_end_date;
2752: EXCEPTION
2753: WHEN OTHERS THEN