39:
40: PROCEDURE Insert_AWT_Default(
41: P_Invoice_Id IN ap_invoices_all.invoice_id%TYPE,
42: P_Inv_Dist_Id IN ap_invoice_distributions_all.invoice_distribution_id%TYPE,
43: P_Supp_Awt_Code_Id IN jl_zz_ap_sup_awt_cd.supp_awt_code_id%TYPE,
44: p_calling_sequence IN VARCHAR2,
45: P_Org_Id IN jl_zz_ap_sup_awt_cd.org_id%TYPE) IS
46:
47: Seq_Inv_Dis_Awt_Id NUMBER;
41: P_Invoice_Id IN ap_invoices_all.invoice_id%TYPE,
42: P_Inv_Dist_Id IN ap_invoice_distributions_all.invoice_distribution_id%TYPE,
43: P_Supp_Awt_Code_Id IN jl_zz_ap_sup_awt_cd.supp_awt_code_id%TYPE,
44: p_calling_sequence IN VARCHAR2,
45: P_Org_Id IN jl_zz_ap_sup_awt_cd.org_id%TYPE) IS
46:
47: Seq_Inv_Dis_Awt_Id NUMBER;
48: l_debug_loc VARCHAR2(30) := ' Insert_AWT_Default ';
49: l_curr_calling_sequence VARCHAR2(2000);
568: awt.jurisdiction_type,
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