APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on AP_TAX_CODES_ALL

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