APPS.PAY_RI_AC_TAX_RULE dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 10: l_pay_ca_provtax_rule_rec PAY_CA_EMP_PROV_TAX_INFO_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);
12: g_assignment varchar2(20);
13: g_link_value number(15);
14: g_user_sequence number(15);

Line 640: ,p_base_table_name => 'PAY_CA_EMP_PROV_TAX_INFO_F'

636:
637: -- check for valid datatrack update modes
638: Dt_Api.Find_DT_Upd_Modes
639: (p_effective_date => l_effective_date
640: ,p_base_table_name => 'PAY_CA_EMP_PROV_TAX_INFO_F'
641: ,p_base_key_column => 'EMP_PROVINCE_TAX_INF_ID'
642: ,p_base_key_value => l_pay_ca_provtax_rule_rec.EMP_PROVINCE_TAX_INF_ID
643: ,p_correction => l_dt_correction
644: ,p_update => l_dt_update

Line 940: ln_caprovtax_inf_id PAY_CA_EMP_PROV_TAX_INFO_F.EMP_PROVINCE_TAX_INF_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:
942: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
943: ln_batch_exists number;
944: lv_lookup_code varchar2(20);

Line 1063: from PAY_CA_EMP_PROV_TAX_INFO_F pti

1059:
1060: /* Check Canada Provincial Tax Record */
1061: CURSOR csr_get_caprovtax_id(cp_asg_id number) is
1062: select pti.EMP_PROVINCE_TAX_INF_ID,pti.object_version_number
1063: from PAY_CA_EMP_PROV_TAX_INFO_F pti
1064: where pti.assignment_id = cp_asg_id
1065: and p_effective_date between pti.effective_start_date and pti.effective_end_date
1066: and pti.business_group_id = p_business_group
1067: and pti.province_code = ltrim(rtrim(p_state_prov_code));