APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_CA_EMP_FED_TAX_INFO_F

Line 4972: --to update pay_ca_emp_fed_tax_info_f.employment_province,

4968: --
4969: --
4970: --
4971: --Per bug 2996546,Added a new procedure update_ca_emp_info
4972: --to update pay_ca_emp_fed_tax_info_f.employment_province,
4973: --pay_ca_emp_prov_tax_info_f.province_code,
4974: --pay_ca_legislation_info.jurisdiction_code
4975: --
4976: --

Line 4984: FROM pay_ca_emp_fed_tax_info_f cafed,

4980:
4981: IS
4982: CURSOR canada_emp_fed_tax_cur IS
4983: SELECT distinct cafed.employment_province, cafed.assignment_id
4984: FROM pay_ca_emp_fed_tax_info_f cafed,
4985: pay_us_modified_geocodes pmod
4986: WHERE pmod.state_code = 'CA'
4987: AND pmod.county_code = cafed.employment_province
4988: AND pmod.patch_name = p_patch_name;

Line 5014: new_geocode pay_ca_emp_fed_tax_info_f .employment_province%TYPE;

5010: canada_leg_info_rec canada_leg_info_cur%ROWTYPE;
5011:
5012:
5013:
5014: new_geocode pay_ca_emp_fed_tax_info_f .employment_province%TYPE;
5015: new_geocode1 pay_ca_emp_prov_tax_info_f.province_code%TYPE;
5016: new_geocode2 pay_ca_legislation_info. jurisdiction_code%TYPE;
5017: l_proc_type pay_us_modified_geocodes.process_type%TYPE;
5018: l_error_message_text varchar2(240);

Line 5046: UPDATE pay_ca_emp_fed_tax_info_f

5042:
5043: IF G_MODE = 'UPGRADE' THEN
5044:
5045:
5046: UPDATE pay_ca_emp_fed_tax_info_f
5047: SET employment_province = new_geocode
5048: WHERE employment_province = canada_emp_fed_rec.employment_province
5049: AND assignment_id = canada_emp_fed_rec.assignment_id ;
5050:

Line 5065: p_location => 'PAY_CA_EMP_FED_TAX_INFO_F',

5061: p_person_id => null,
5062: p_assign_id => canada_emp_fed_rec.assignment_id,
5063: p_old_juri_code => canada_emp_fed_rec.employment_province,
5064: p_new_juri_code => new_geocode,
5065: p_location => 'PAY_CA_EMP_FED_TAX_INFO_F',
5066: p_id => null);
5067:
5068: hr_utility.set_location('pay_us_geo_upd_pkg.update_ca_emp_info',3);
5069: