[Home] [Help]
1: package body pay_ri_ac_tax_rule as
2: /* $Header: payacemptaxwrap.pkb 120.3 2012/03/01 13:00:25 rgottipa noship $ */
3:
4: l_pay_us_fedtax_rule_rec pay_us_emp_fed_tax_rules_f%ROWTYPE;
5: l_pay_us_statetax_rule_rec PAY_US_EMP_STATE_TAX_RULES_F%ROWTYPE;
6: l_pay_us_countytax_rule_rec PAY_US_EMP_COUNTY_TAX_RULES_F%ROWTYPE;
7: l_pay_us_citytax_rule_rec PAY_US_EMP_CITY_TAX_RULES_F%ROWTYPE;
8:
9: l_pay_ca_fedtax_rule_rec PAY_CA_EMP_FED_TAX_INFO_F%ROWTYPE;
126:
127: -- check for valid datatrack update modes
128: Dt_Api.Find_DT_Upd_Modes
129: (p_effective_date => l_effective_date
130: ,p_base_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F'
131: ,p_base_key_column => 'EMP_STATE_TAX_RULE_ID'
132: ,p_base_key_value => l_pay_us_statetax_rule_rec.EMP_STATE_TAX_RULE_ID
133: ,p_correction => l_dt_correction
134: ,p_update => l_dt_update
932: ,p_additional_info10 in number default hr_api.g_number
933: ) is
934:
935: ln_fedtax_rule_id pay_us_emp_fed_tax_rules_f.EMP_FED_TAX_RULE_ID%TYPE;
936: ln_statetax_rule_id pay_us_emp_state_tax_rules_f.EMP_state_TAX_RULE_ID%TYPE;
937: ln_countytax_rule_id pay_us_emp_county_tax_rules_f.EMP_county_TAX_RULE_ID%TYPE;
938: ln_citytax_rule_id pay_us_emp_city_tax_rules_f.EMP_city_TAX_RULE_ID%TYPE;
939: ln_cafedtax_inf_id PAY_CA_EMP_FED_TAX_INFO_F.EMP_FED_TAX_INF_ID%TYPE;
940: ln_caprovtax_inf_id PAY_CA_EMP_PROV_TAX_INFO_F.EMP_PROVINCE_TAX_INF_ID%TYPE;
962:
963: /* US Employee State Tax Rule record */
964: CURSOR csr_get_statetax_id(cp_asg_id number) is
965: select str.EMP_STATE_TAX_RULE_ID,str.object_version_number
966: from PAY_US_EMP_STATE_TAX_RULES_F str
967: where str.assignment_id = cp_asg_id
968: and p_effective_date between str.effective_start_date and str.effective_end_date
969: and str.business_group_id = p_business_group
970: and str.state_code = ltrim(rtrim(p_state_prov_code));