APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on AP_TAX_CODES_ALL

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