DBA Data[Home] [Help]

APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on AP_TAX_CODES

Line 379: ,v_tax_id ap_tax_codes_all.tax_id%type)

375: -----------------------------------------------------*/
376:
377: FUNCTION Validate_Line_Type
378: (v_dist_type varchar2
379: ,v_tax_id ap_tax_codes_all.tax_id%type)
380: return boolean is
381: v_item_type ap_tax_codes_all.global_attribute8%type;
382: v_freight_type ap_tax_codes_all.global_attribute9%type;
383: v_misc_type ap_tax_codes_all.global_attribute10%type;

Line 381: v_item_type ap_tax_codes_all.global_attribute8%type;

377: FUNCTION Validate_Line_Type
378: (v_dist_type varchar2
379: ,v_tax_id ap_tax_codes_all.tax_id%type)
380: return boolean is
381: v_item_type ap_tax_codes_all.global_attribute8%type;
382: v_freight_type ap_tax_codes_all.global_attribute9%type;
383: v_misc_type ap_tax_codes_all.global_attribute10%type;
384: v_tax_type ap_tax_codes_all.global_attribute11%type;
385: find_type boolean;

Line 382: v_freight_type ap_tax_codes_all.global_attribute9%type;

378: (v_dist_type varchar2
379: ,v_tax_id ap_tax_codes_all.tax_id%type)
380: return boolean is
381: v_item_type ap_tax_codes_all.global_attribute8%type;
382: v_freight_type ap_tax_codes_all.global_attribute9%type;
383: v_misc_type ap_tax_codes_all.global_attribute10%type;
384: v_tax_type ap_tax_codes_all.global_attribute11%type;
385: find_type boolean;
386:

Line 383: v_misc_type ap_tax_codes_all.global_attribute10%type;

379: ,v_tax_id ap_tax_codes_all.tax_id%type)
380: return boolean is
381: v_item_type ap_tax_codes_all.global_attribute8%type;
382: v_freight_type ap_tax_codes_all.global_attribute9%type;
383: v_misc_type ap_tax_codes_all.global_attribute10%type;
384: v_tax_type ap_tax_codes_all.global_attribute11%type;
385: find_type boolean;
386:
387: CURSOR cur_validate_line_type is

Line 384: v_tax_type ap_tax_codes_all.global_attribute11%type;

380: return boolean is
381: v_item_type ap_tax_codes_all.global_attribute8%type;
382: v_freight_type ap_tax_codes_all.global_attribute9%type;
383: v_misc_type ap_tax_codes_all.global_attribute10%type;
384: v_tax_type ap_tax_codes_all.global_attribute11%type;
385: find_type boolean;
386:
387: CURSOR cur_validate_line_type is
388: SELECT global_attribute8, -- Type ITEM

Line 392: FROM ap_tax_codes

388: SELECT global_attribute8, -- Type ITEM
389: global_attribute9, -- Type FREIGHT
390: global_attribute10,-- Type MISCELLANEOUS
391: global_attribute11 -- Type TAX
392: FROM ap_tax_codes
393: WHERE tax_id =v_tax_id;
394:
395: BEGIN
396: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

569: awt.province_code,
570: awt.city_code
571: FROM jl_zz_ap_supp_awt_types swt,
572: jl_zz_ap_sup_awt_cd swc,
573: ap_tax_codes_ALL tca, -- Add _ALL for MOAC
574: jl_zz_ap_awt_types awt
575: WHERE swt.vendor_id = C_vendor_id -- Select only for this Supplier
576: AND swt.wh_subject_flag = 'Y' -- Supp subject to the withholding tax type
577: AND swc.supp_awt_type_id = swt.supp_awt_type_id -- Join

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

737: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
738: 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');
739: END IF;
740: ---------------------------------------------------------------
741: -- The name of the zone is taken from AP_TAX_CODES Global Att 7
742: ---------------------------------------------------------------
743: IF db_reg.global_attribute7 = v_hr_zone THEN
744: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
745: 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');