APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on JL_ZZ_AP_SUP_AWT_CD

Line 434: P_Rec_Suppl_AWT_Name OUT NOCOPY jl_zz_ap_sup_awt_cd%ROWTYPE,

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: P_CODE_ACCOUNTING_DATE IN DATE Default NULL) -- Argentina AWT ER 6624809
436: IS
437: ------------------------------
438: -- Local variables definition

Line 569: FROM jl_zz_ap_sup_awt_cd jlsc

565: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('ACCOUNTING_DATE_before1 = '||to_char(P_CODE_ACCOUNTING_DATE)); -- Argentina AWT ER 6624809
566: --Bug 10060465 Start
567: SELECT *
568: INTO P_Rec_Suppl_AWT_Name
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

Line 586: FROM jl_zz_ap_sup_awt_cd jlsc

582: JL_ZZ_AP_EXT_AWT_UTIL.Debug ('ACCOUNTING_DATE_before2 = '||to_char(P_CODE_ACCOUNTING_DATE));
583:
584: SELECT *
585: INTO P_Rec_Suppl_AWT_Name
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

Line 605: FROM jl_zz_ap_sup_awt_cd jlsc

601:
602:
603: SELECT *
604: INTO P_Rec_Suppl_AWT_Name
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

Line 816: P_Rec_Suppl_AWT_Name IN jl_zz_ap_sup_awt_cd%ROWTYPE,

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,
820: P_Tax_Name_To IN Number,

Line 2727: jl_zz_ap_sup_awt_cd jsw,

2723: ----------------------------------------------------------------------
2724: CURSOR tax_code IS
2725: SELECT distinct atc.name, atc.tax_code_combination_id
2726: FROM jl_zz_ap_inv_dis_wh jid,
2727: jl_zz_ap_sup_awt_cd jsw,
2728: ap_tax_codes atc
2729: WHERE jid.invoice_id = P_Invoice_Id
2730: AND jsw.supp_awt_code_id = jid.supp_awt_code_id
2731: AND atc.tax_id = jsw.tax_id;

Line 2816: FROM jl_zz_ap_sup_awt_cd jsw,

2812: -- Cursor to get the distinct tax codes for the given invoice
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