APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on JL_AR_AP_PROVINCES

Line 158: (P_Province_Code jl_ar_ap_provinces.province_code%TYPE

154: Ver_Territorial_Flag return true if the province is territorial.
155: ---------------------------------------------------------------------------*/
156:
157: FUNCTION Ver_Territorial_Flag
158: (P_Province_Code jl_ar_ap_provinces.province_code%TYPE
159: ) return boolean is
160: -------------------------------------------------------------------------
161: -- Select the flag for province Territory
162: -------------------------------------------------------------------------

Line 165: FROM jl_ar_ap_provinces

161: -- Select the flag for province Territory
162: -------------------------------------------------------------------------
163: CURSOR Province_Territory IS
164: SELECT territorial_flag
165: FROM jl_ar_ap_provinces
166: WHERE province_code = P_Province_Code;
167:
168: v_territory boolean;
169: v_province_terr jl_ar_ap_provinces.territorial_flag%TYPE;

Line 169: v_province_terr jl_ar_ap_provinces.territorial_flag%TYPE;

165: FROM jl_ar_ap_provinces
166: WHERE province_code = P_Province_Code;
167:
168: v_territory boolean;
169: v_province_terr jl_ar_ap_provinces.territorial_flag%TYPE;
170:
171: BEGIN
172: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
173: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Ver_Territorial_Flag','Start FUNCTION Ver_Territorial_Flag');

Line 558: v_provincial_code jl_ar_ap_provinces.province_code%TYPE;

554: AND swc.primary_tax_flag = 'Y' -- Verify the Primary Withholding Tax
555: AND awt.awt_type_code = swt.awt_type_code -- Join
556: ;
557:
558: v_provincial_code jl_ar_ap_provinces.province_code%TYPE;
559:
560: v_hr_zone hr_locations_all.region_1%TYPE;
561: v_hr_province hr_locations_all.region_2%TYPE;
562: v_hr_city hr_locations_all.town_or_city%TYPE;