APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 3701: --pay_ca_emp_prov_tax_info_f.province_code,

3697: --
3698: --
3699: --Per bug 2996546,Added a new procedure update_ca_emp_info
3700: --to update pay_ca_emp_fed_tax_info_f.employment_province,
3701: --pay_ca_emp_prov_tax_info_f.province_code,
3702: --pay_ca_legislation_info.jurisdiction_code
3703: --
3704: --
3705: PROCEDURE update_ca_emp_info (P_GEO_PHASE_ID IN NUMBER,

Line 3722: FROM pay_ca_emp_prov_tax_info_f caprov,

3718: canada_emp_fed_rec canada_emp_fed_tax_cur%ROWTYPE;
3719:
3720: CURSOR canada_emp_prov_tax_cur IS
3721: SELECT distinct caprov.province_code, caprov.assignment_id
3722: FROM pay_ca_emp_prov_tax_info_f caprov,
3723: pay_us_modified_geocodes pmod
3724: WHERE pmod.state_code = 'CA'
3725: AND pmod.county_code = caprov.province_code
3726: AND pmod.patch_name = p_patch_name;

Line 3743: new_geocode1 pay_ca_emp_prov_tax_info_f.province_code%TYPE;

3739:
3740:
3741:
3742: new_geocode pay_ca_emp_fed_tax_info_f .employment_province%TYPE;
3743: new_geocode1 pay_ca_emp_prov_tax_info_f.province_code%TYPE;
3744: new_geocode2 pay_ca_legislation_info. jurisdiction_code%TYPE;
3745: l_proc_type pay_us_modified_geocodes.process_type%TYPE;
3746: l_error_message_text varchar2(240);
3747:

Line 3820: UPDATE pay_ca_emp_prov_tax_info_f

3816:
3817: IF G_MODE = 'UPGRADE' THEN
3818:
3819:
3820: UPDATE pay_ca_emp_prov_tax_info_f
3821: SET province_code = new_geocode1
3822: WHERE province_code = canada_emp_prov_rec.province_code
3823: AND assignment_id = canada_emp_prov_rec.assignment_id ;
3824:

Line 3839: p_location => 'PAY_CA_EMP_PROV_TAX_INFO_F',

3835: p_person_id => null,
3836: p_assign_id => canada_emp_prov_rec.assignment_id,
3837: p_old_juri_code => canada_emp_prov_rec.province_code,
3838: p_new_juri_code => new_geocode1,
3839: p_location => 'PAY_CA_EMP_PROV_TAX_INFO_F',
3840: p_id => null);
3841:
3842: hr_utility.set_location('pay_us_geo_upd_pkg.update_ca_emp_info',6);
3843: END LOOP ;