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_RI_AC_TAX_RULE dependencies on PAY_US_EMP_COUNTY_TAX_RULES_F

Line 6: l_pay_us_countytax_rule_rec PAY_US_EMP_COUNTY_TAX_RULES_F%ROWTYPE;

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;
10: l_pay_ca_provtax_rule_rec PAY_CA_EMP_PROV_TAX_INFO_F%ROWTYPE;

Line 296: ,p_base_table_name => 'PAY_US_EMP_COUNTY_TAX_RULES_F'

292:
293: -- check for valid datatrack update modes
294: Dt_Api.Find_DT_Upd_Modes
295: (p_effective_date => l_effective_date
296: ,p_base_table_name => 'PAY_US_EMP_COUNTY_TAX_RULES_F'
297: ,p_base_key_column => 'EMP_COUNTY_TAX_RULE_ID'
298: ,p_base_key_value => l_pay_us_countytax_rule_rec.EMP_COUNTY_TAX_RULE_ID
299: ,p_correction => l_dt_correction
300: ,p_update => l_dt_update

Line 937: ln_countytax_rule_id pay_us_emp_county_tax_rules_f.EMP_county_TAX_RULE_ID%TYPE;

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;
941:

Line 976: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr

972:
973: /* US Employee County Tax Rule record */
974: CURSOR csr_get_countytax_id(cp_asg_id number,cp_county_code varchar2) is
975: select ctr.EMP_COUNTY_TAX_RULE_ID,ctr.object_version_number
976: from PAY_US_EMP_COUNTY_TAX_RULES_F ctr
977: where ctr.assignment_id = cp_asg_id
978: and p_effective_date between ctr.effective_start_date and ctr.effective_end_date
979: and ctr.business_group_id = p_business_group
980: and ctr.state_code = ltrim(rtrim(p_state_prov_code))