DBA Data[Home] [Help]

APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on JL_ZZ_AP_SUPP_AWT_TYPES

Line 534: CURSOR Supp_Wh_Types(C_Vendor_Id jl_zz_ap_supp_awt_types.vendor_id%TYPE) Is

530: ) IS
531: ---------------------------------------------------------------------
532: -- Cursor Supplier Withholding Types.
533: ---------------------------------------------------------------------
534: CURSOR Supp_Wh_Types(C_Vendor_Id jl_zz_ap_supp_awt_types.vendor_id%TYPE) Is
535: SELECT swt.supp_awt_type_id ,
536: swt.awt_type_code,
537: swc.supp_awt_code_id,
538: swc.org_id, -- Add Org_ID for MOAC

Line 544: FROM jl_zz_ap_supp_awt_types swt,

540: tca.global_attribute7, -- Zone
541: awt.jurisdiction_type,
542: awt.province_code,
543: awt.city_code
544: FROM jl_zz_ap_supp_awt_types swt,
545: jl_zz_ap_sup_awt_cd swc,
546: ap_tax_codes_ALL tca, -- Add _ALL for MOAC
547: jl_zz_ap_awt_types awt
548: WHERE swt.vendor_id = C_vendor_id -- Select only for this Supplier