APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_CA_LEGISLATION_INFO

Line 4974: --pay_ca_legislation_info.jurisdiction_code

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,
4978: P_MODE IN VARCHAR2,

Line 5004: FROM pay_ca_legislation_info caleg,

5000: canada_emp_prov_rec canada_emp_prov_tax_cur%ROWTYPE;
5001:
5002: CURSOR canada_leg_info_cur IS
5003: SELECT distinct caleg.jurisdiction_code
5004: FROM pay_ca_legislation_info caleg,
5005: pay_us_modified_geocodes pmod
5006: WHERE pmod.state_code = 'CA'
5007: AND pmod.county_code = caleg.jurisdiction_code
5008: AND pmod.patch_name = p_patch_name ;

Line 5016: new_geocode2 pay_ca_legislation_info. jurisdiction_code%TYPE;

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:
5020: BEGIN

Line 5136: UPDATE pay_ca_legislation_info

5132: AND pmod.patch_name = p_patch_name;
5133:
5134: IF G_MODE = 'UPGRADE' THEN
5135:
5136: UPDATE pay_ca_legislation_info
5137: SET jurisdiction_code = new_geocode2
5138: WHERE jurisdiction_code = canada_leg_info_rec.jurisdiction_code ;
5139: -- COMMIT;
5140:

Line 5152: p_location => 'PAY_CA_LEGISLATION_INFO',

5148: p_person_id => null,
5149: p_assign_id => null,
5150: p_old_juri_code => canada_leg_info_rec.jurisdiction_code,
5151: p_new_juri_code => new_geocode2,
5152: p_location => 'PAY_CA_LEGISLATION_INFO',
5153: p_id => null);
5154:
5155: hr_utility.set_location('pay_us_geo_upd_pkg.update_ca_emp_info',9);
5156: END LOOP ;