APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on JL_ZZ_AP_SUPP_AWT_TYPES

Line 364: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE)

360: PROCEDURE Initialize_Withholding_Type
361: (P_AWT_Type_Code IN Varchar2,
362: P_Vendor_Id IN Number,
363: P_Rec_AWT_Type OUT NOCOPY jl_zz_ap_awt_types%ROWTYPE,
364: P_Rec_Suppl_AWT_Type OUT NOCOPY jl_zz_ap_supp_awt_types%ROWTYPE)
365: IS
366: ------------------------------
367: -- Local variables definition
368: ------------------------------

Line 395: FROM jl_zz_ap_supp_awt_types

391: -----------------------------------------------------------
392: l_debug_info := 'Obtains withholding tax type attributes for the supplier';
393: SELECT *
394: INTO P_Rec_Suppl_AWT_Type
395: FROM jl_zz_ap_supp_awt_types
396: WHERE awt_type_code = P_AWT_Type_Code
397: AND vendor_id = P_Vendor_Id;
398:
399: EXCEPTION

Line 569: FROM jl_zz_ap_supp_awt_types jlst

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
570: WHERE jlst.awt_type_code = P_AWT_Type_Code
571: AND jlst.vendor_id = P_Vendor_Id);
572:
573: EXCEPTION

Line 772: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,

768: PROCEDURE Process_Withholding_Name
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,

Line 1735: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,

1731: * *
1732: **************************************************************************/
1733: PROCEDURE Process_Withholding_Type
1734: (P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
1735: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,
1736: P_AWT_Date IN Date,
1737: P_Currency_Code IN Varchar2,
1738: P_Tab_Withhold IN OUT NOCOPY Tab_Withholding)
1739: IS

Line 2859: jl_zz_ap_supp_awt_types jst,

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
2863: AND jst.vendor_id = aii.vendor_id