APPS.PAY_RI_AC_TAX_RULE dependencies on PAY_US_EMP_CITY_TAX_RULES_F

Line 7: l_pay_us_citytax_rule_rec PAY_US_EMP_CITY_TAX_RULES_F%ROWTYPE;

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;
11: g_employee varchar2(250);

Line 386: ,p_base_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F'

382:
383: -- check for valid datatrack update modes
384: Dt_Api.Find_DT_Upd_Modes
385: (p_effective_date => l_effective_date
386: ,p_base_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F'
387: ,p_base_key_column => 'EMP_CITY_TAX_RULE_ID'
388: ,p_base_key_value => l_pay_us_citytax_rule_rec.EMP_CITY_TAX_RULE_ID
389: ,p_correction => l_dt_correction
390: ,p_update => l_dt_update

Line 932: ln_citytax_rule_id pay_us_emp_city_tax_rules_f.EMP_city_TAX_RULE_ID%TYPE;

928:
929: ln_fedtax_rule_id pay_us_emp_fed_tax_rules_f.EMP_FED_TAX_RULE_ID%TYPE;
930: ln_statetax_rule_id pay_us_emp_state_tax_rules_f.EMP_state_TAX_RULE_ID%TYPE;
931: ln_countytax_rule_id pay_us_emp_county_tax_rules_f.EMP_county_TAX_RULE_ID%TYPE;
932: ln_citytax_rule_id pay_us_emp_city_tax_rules_f.EMP_city_TAX_RULE_ID%TYPE;
933: ln_cafedtax_inf_id PAY_CA_EMP_FED_TAX_INFO_F.EMP_FED_TAX_INF_ID%TYPE;
934: ln_caprovtax_inf_id PAY_CA_EMP_PROV_TAX_INFO_F.EMP_PROVINCE_TAX_INF_ID%TYPE;
935:
936: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 997: from PAY_US_EMP_CITY_TAX_RULES_F ctr

993: CURSOR csr_get_citytax_id(cp_asg_id number,
994: cp_county_code varchar2,
995: cp_city_code varchar2) is
996: select ctr.EMP_CITY_TAX_RULE_ID,ctr.object_version_number
997: from PAY_US_EMP_CITY_TAX_RULES_F ctr
998: where ctr.assignment_id = cp_asg_id
999: and ctr.business_group_id = p_business_group
1000: and p_effective_date between ctr.effective_start_date and ctr.effective_end_date
1001: and ctr.state_code = ltrim(rtrim(p_state_prov_code))