APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_CA_EMP_FED_TAX_INFO_F

Line 3700: --to update pay_ca_emp_fed_tax_info_f.employment_province,

3696: --
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: --

Line 3712: FROM pay_ca_emp_fed_tax_info_f cafed,

3708:
3709: IS
3710: CURSOR canada_emp_fed_tax_cur IS
3711: SELECT distinct cafed.employment_province, cafed.assignment_id
3712: FROM pay_ca_emp_fed_tax_info_f cafed,
3713: pay_us_modified_geocodes pmod
3714: WHERE pmod.state_code = 'CA'
3715: AND pmod.county_code = cafed.employment_province
3716: AND pmod.patch_name = p_patch_name;

Line 3742: new_geocode pay_ca_emp_fed_tax_info_f .employment_province%TYPE;

3738: canada_leg_info_rec canada_leg_info_cur%ROWTYPE;
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);

Line 3774: UPDATE pay_ca_emp_fed_tax_info_f

3770:
3771: IF G_MODE = 'UPGRADE' THEN
3772:
3773:
3774: UPDATE pay_ca_emp_fed_tax_info_f
3775: SET employment_province = new_geocode
3776: WHERE employment_province = canada_emp_fed_rec.employment_province
3777: AND assignment_id = canada_emp_fed_rec.assignment_id ;
3778:

Line 3793: p_location => 'PAY_CA_EMP_FED_TAX_INFO_F',

3789: p_person_id => null,
3790: p_assign_id => canada_emp_fed_rec.assignment_id,
3791: p_old_juri_code => canada_emp_fed_rec.employment_province,
3792: p_new_juri_code => new_geocode,
3793: p_location => 'PAY_CA_EMP_FED_TAX_INFO_F',
3794: p_id => null);
3795:
3796: hr_utility.set_location('pay_us_geo_upd_pkg.update_ca_emp_info',3);
3797: