APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 4973: --pay_ca_emp_prov_tax_info_f.province_code,

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: --
4977: PROCEDURE update_ca_emp_info (P_GEO_PHASE_ID IN NUMBER,

Line 4994: FROM pay_ca_emp_prov_tax_info_f caprov,

4990: canada_emp_fed_rec canada_emp_fed_tax_cur%ROWTYPE;
4991:
4992: CURSOR canada_emp_prov_tax_cur IS
4993: SELECT distinct caprov.province_code, caprov.assignment_id
4994: FROM pay_ca_emp_prov_tax_info_f caprov,
4995: pay_us_modified_geocodes pmod
4996: WHERE pmod.state_code = 'CA'
4997: AND pmod.county_code = caprov.province_code
4998: AND pmod.patch_name = p_patch_name;

Line 5015: new_geocode1 pay_ca_emp_prov_tax_info_f.province_code%TYPE;

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);
5019:

Line 5092: UPDATE pay_ca_emp_prov_tax_info_f

5088:
5089: IF G_MODE = 'UPGRADE' THEN
5090:
5091:
5092: UPDATE pay_ca_emp_prov_tax_info_f
5093: SET province_code = new_geocode1
5094: WHERE province_code = canada_emp_prov_rec.province_code
5095: AND assignment_id = canada_emp_prov_rec.assignment_id ;
5096:

Line 5111: p_location => 'PAY_CA_EMP_PROV_TAX_INFO_F',

5107: p_person_id => null,
5108: p_assign_id => canada_emp_prov_rec.assignment_id,
5109: p_old_juri_code => canada_emp_prov_rec.province_code,
5110: p_new_juri_code => new_geocode1,
5111: p_location => 'PAY_CA_EMP_PROV_TAX_INFO_F',
5112: p_id => null);
5113:
5114: hr_utility.set_location('pay_us_geo_upd_pkg.update_ca_emp_info',6);
5115: END LOOP ;