APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on AP_TAX_CODES

Line 353: ,v_tax_id ap_tax_codes_all.tax_id%type)

349: -----------------------------------------------------*/
350:
351: FUNCTION Validate_Line_Type
352: (v_dist_type varchar2
353: ,v_tax_id ap_tax_codes_all.tax_id%type)
354: return boolean is
355: v_item_type ap_tax_codes_all.global_attribute8%type;
356: v_freight_type ap_tax_codes_all.global_attribute9%type;
357: v_misc_type ap_tax_codes_all.global_attribute10%type;

Line 355: v_item_type ap_tax_codes_all.global_attribute8%type;

351: FUNCTION Validate_Line_Type
352: (v_dist_type varchar2
353: ,v_tax_id ap_tax_codes_all.tax_id%type)
354: return boolean is
355: v_item_type ap_tax_codes_all.global_attribute8%type;
356: v_freight_type ap_tax_codes_all.global_attribute9%type;
357: v_misc_type ap_tax_codes_all.global_attribute10%type;
358: v_tax_type ap_tax_codes_all.global_attribute11%type;
359: find_type boolean;

Line 356: v_freight_type ap_tax_codes_all.global_attribute9%type;

352: (v_dist_type varchar2
353: ,v_tax_id ap_tax_codes_all.tax_id%type)
354: return boolean is
355: v_item_type ap_tax_codes_all.global_attribute8%type;
356: v_freight_type ap_tax_codes_all.global_attribute9%type;
357: v_misc_type ap_tax_codes_all.global_attribute10%type;
358: v_tax_type ap_tax_codes_all.global_attribute11%type;
359: find_type boolean;
360:

Line 357: v_misc_type ap_tax_codes_all.global_attribute10%type;

353: ,v_tax_id ap_tax_codes_all.tax_id%type)
354: return boolean is
355: v_item_type ap_tax_codes_all.global_attribute8%type;
356: v_freight_type ap_tax_codes_all.global_attribute9%type;
357: v_misc_type ap_tax_codes_all.global_attribute10%type;
358: v_tax_type ap_tax_codes_all.global_attribute11%type;
359: find_type boolean;
360:
361: CURSOR cur_validate_line_type is

Line 358: v_tax_type ap_tax_codes_all.global_attribute11%type;

354: return boolean is
355: v_item_type ap_tax_codes_all.global_attribute8%type;
356: v_freight_type ap_tax_codes_all.global_attribute9%type;
357: v_misc_type ap_tax_codes_all.global_attribute10%type;
358: v_tax_type ap_tax_codes_all.global_attribute11%type;
359: find_type boolean;
360:
361: CURSOR cur_validate_line_type is
362: SELECT global_attribute8, -- Type ITEM

Line 366: FROM ap_tax_codes

362: SELECT global_attribute8, -- Type ITEM
363: global_attribute9, -- Type FREIGHT
364: global_attribute10,-- Type MISCELLANEOUS
365: global_attribute11 -- Type TAX
366: FROM ap_tax_codes
367: WHERE tax_id =v_tax_id;
368:
369: BEGIN
370: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 546: ap_tax_codes_ALL tca, -- Add _ALL for MOAC

542: awt.province_code,
543: awt.city_code
544: FROM jl_zz_ap_supp_awt_types swt,
545: jl_zz_ap_sup_awt_cd swc,
546: ap_tax_codes_ALL tca, -- Add _ALL for MOAC
547: jl_zz_ap_awt_types awt
548: WHERE swt.vendor_id = C_vendor_id -- Select only for this Supplier
549: AND swt.wh_subject_flag = 'Y' -- Supp subject to the withholding tax type
550: AND swc.supp_awt_type_id = swt.supp_awt_type_id -- Join

Line 707: -- The name of the zone is taken from AP_TAX_CODES Global Att 7

703: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
704: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def_Line','Inside ELSIF db_reg.jurisdiction_type = ZONAL THEN');
705: END IF;
706: ---------------------------------------------------------------
707: -- The name of the zone is taken from AP_TAX_CODES Global Att 7
708: ---------------------------------------------------------------
709: IF db_reg.global_attribute7 = v_hr_zone THEN
710: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
711: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_ZZ_AP_AWT_DEFAULT_PKG.Supp_Wh_Def_Line','Inside IF db_reg.global_attribute7 = v_hr_zone THEN');