[Home] [Help]
430: (P_AWT_Type_Code IN Varchar2,
431: P_Tax_Id IN Number,
432: P_Vendor_Id IN Number,
433: P_AWT_Name OUT NOCOPY Rec_AWT_Code,
434: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE)
435: IS
436: ------------------------------
437: -- Local variables definition
438: ------------------------------
561: -----------------------------------------------------------
562: l_debug_info := 'Obtain tax name attributes for the supplier';
563: SELECT *
564: INTO P_Rec_Suppl_AWT_Name
565: FROM jl_zz_ap_sup_awt_cd jlsc
566: WHERE jlsc.tax_id = P_Tax_Id
567: AND jlsc.supp_awt_type_id =
568: (SELECT jlst.supp_awt_type_id
569: FROM jl_zz_ap_supp_awt_types jlst
769: (P_Vendor_Id IN Number,
770: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
771: P_Rec_AWT_Name IN Rec_AWT_CODE,
772: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,
773: P_Rec_Suppl_AWT_Name IN jl_zz_ap_sup_awt_cd%ROWTYPE,
774: P_AWT_Date IN Date,
775: P_Tab_Withhold IN OUT NOCOPY Tab_Withholding,
776: P_Tax_Name_From IN Number,
777: P_Tax_Name_To IN Number,
2766: ----------------------------------------------------------------------
2767: CURSOR tax_code IS
2768: SELECT distinct atc.name, atc.tax_code_combination_id
2769: FROM jl_zz_ap_inv_dis_wh jid,
2770: jl_zz_ap_sup_awt_cd jsw,
2771: ap_tax_codes atc
2772: WHERE jid.invoice_id = P_Invoice_Id
2773: AND jsw.supp_awt_code_id = jid.supp_awt_code_id
2774: AND atc.tax_id = jsw.tax_id;
2854: -- Cursor to get the distinct tax codes for the given invoice
2855: ----------------------------------------------------------------------
2856: CURSOR tax_code IS
2857: SELECT distinct atc.name, atc.tax_code_combination_id
2858: FROM jl_zz_ap_sup_awt_cd jsw,
2859: jl_zz_ap_supp_awt_types jst,
2860: ap_tax_codes atc,
2861: ap_invoices_interface aii
2862: WHERE aii.invoice_id = P_Invoice_id