DBA Data[Home] [Help]

APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on HR_LOCATIONS_ALL

Line 761: v_hr_zone hr_locations_all.region_1%TYPE;

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';

Line 762: v_hr_province hr_locations_all.region_2%TYPE;

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:

Line 763: v_hr_city hr_locations_all.town_or_city%TYPE;

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: