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 573: FROM jl_zz_ap_supp_awt_types jlst

569: FROM jl_zz_ap_sup_awt_cd jlsc
570: WHERE jlsc.tax_id = P_Tax_Id -- Argentina AWT code change
571: AND jlsc.supp_awt_type_id =
572: (SELECT jlst.supp_awt_type_id
573: FROM jl_zz_ap_supp_awt_types jlst
574: WHERE jlst.awt_type_code = P_AWT_Type_Code
575: AND jlst.vendor_id = P_Vendor_Id)
576: AND NVL(To_Date(P_CODE_ACCOUNTING_DATE),sysdate) between
577: NVL(jlsc.effective_start_date,To_Date('01-01-1950', 'DD-MM-YYYY'))

Line 590: FROM jl_zz_ap_supp_awt_types jlst

586: FROM jl_zz_ap_sup_awt_cd jlsc
587: WHERE jlsc.tax_id = P_Tax_Id -- Argentina AWT code change
588: AND jlsc.supp_awt_type_id =
589: (SELECT jlst.supp_awt_type_id
590: FROM jl_zz_ap_supp_awt_types jlst
591: WHERE jlst.awt_type_code = P_AWT_Type_Code
592: AND jlst.vendor_id = P_Vendor_Id)
593: AND NVL(To_Date(P_CODE_ACCOUNTING_DATE),sysdate) between
594: NVL(jlsc.effective_start_date,To_Date('01-01-1950', 'DD-MM-YYYY'))

Line 609: FROM jl_zz_ap_supp_awt_types jlst

605: FROM jl_zz_ap_sup_awt_cd jlsc
606: WHERE jlsc.tax_id = P_Tax_Id
607: AND jlsc.supp_awt_type_id =
608: (SELECT jlst.supp_awt_type_id
609: FROM jl_zz_ap_supp_awt_types jlst
610: WHERE jlst.awt_type_code = P_AWT_Type_Code
611: AND jlst.vendor_id = P_Vendor_Id);
612:
613: END IF; -- Argentina AWT ER 6624809

Line 815: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,

811: PROCEDURE Process_Withholding_Name
812: (P_Vendor_Id IN Number,
813: P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
814: P_Rec_AWT_Name IN Rec_AWT_CODE,
815: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,
816: P_Rec_Suppl_AWT_Name IN jl_zz_ap_sup_awt_cd%ROWTYPE,
817: P_AWT_Date IN Date,
818: P_Tab_Withhold IN OUT NOCOPY Tab_Withholding,
819: P_Tax_Name_From IN Number,

Line 1685: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,

1681: * *
1682: **************************************************************************/
1683: PROCEDURE Process_Withholding_Type
1684: (P_Rec_AWT_Type IN jl_zz_ap_awt_types%ROWTYPE,
1685: P_Rec_Suppl_AWT_Type IN jl_zz_ap_supp_awt_types%ROWTYPE,
1686: P_AWT_Date IN Date,
1687: P_Currency_Code IN Varchar2,
1688: P_Tab_Withhold IN OUT NOCOPY Tab_Withholding)
1689: IS

Line 2817: jl_zz_ap_supp_awt_types jst,

2813: ----------------------------------------------------------------------
2814: CURSOR tax_code IS
2815: SELECT distinct atc.name, atc.tax_code_combination_id
2816: FROM jl_zz_ap_sup_awt_cd jsw,
2817: jl_zz_ap_supp_awt_types jst,
2818: ap_tax_codes atc,
2819: ap_invoices_interface aii
2820: WHERE aii.invoice_id = P_Invoice_id
2821: AND jst.vendor_id = aii.vendor_id