757: AND sysdate between nvl(swc.effective_start_date,sysdate) and nvl(swc.effective_end_date,sysdate)
758: ; -- New Argentine AWT ER 6624809
759:
760: v_provincial_code jl_ar_ap_provinces.province_code%TYPE;
761: v_hr_zone hr_locations_all.region_1%TYPE;
762: v_hr_province hr_locations_all.region_2%TYPE;
763: v_hr_city hr_locations_all.town_or_city%TYPE;
764: --pc_vendor_id number;
765: p_calling_sequence varchar2(2000):= 'Mono_trib_Supp_Wth';
758: ; -- New Argentine AWT ER 6624809
759:
760: v_provincial_code jl_ar_ap_provinces.province_code%TYPE;
761: v_hr_zone hr_locations_all.region_1%TYPE;
762: v_hr_province hr_locations_all.region_2%TYPE;
763: v_hr_city hr_locations_all.town_or_city%TYPE;
764: --pc_vendor_id number;
765: p_calling_sequence varchar2(2000):= 'Mono_trib_Supp_Wth';
766:
759:
760: v_provincial_code jl_ar_ap_provinces.province_code%TYPE;
761: v_hr_zone hr_locations_all.region_1%TYPE;
762: v_hr_province hr_locations_all.region_2%TYPE;
763: v_hr_city hr_locations_all.town_or_city%TYPE;
764: --pc_vendor_id number;
765: p_calling_sequence varchar2(2000):= 'Mono_trib_Supp_Wth';
766:
767: