APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on JL_ZZ_AP_SUPP_AWT_TYPES

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

557: ) IS
558: ---------------------------------------------------------------------
559: -- Cursor Supplier Withholding Types.
560: ---------------------------------------------------------------------
561: CURSOR Supp_Wh_Types(C_Vendor_Id jl_zz_ap_supp_awt_types.vendor_id%TYPE) Is
562: SELECT swt.supp_awt_type_id ,
563: swt.awt_type_code,
564: swc.supp_awt_code_id,
565: swc.org_id, -- Add Org_ID for MOAC

Line 571: FROM jl_zz_ap_supp_awt_types swt,

567: tca.global_attribute7, -- Zone
568: awt.jurisdiction_type,
569: awt.province_code,
570: awt.city_code
571: FROM jl_zz_ap_supp_awt_types swt,
572: jl_zz_ap_sup_awt_cd swc,
573: ap_tax_codes_ALL tca, -- Add _ALL for MOAC
574: jl_zz_ap_awt_types awt
575: WHERE swt.vendor_id = C_vendor_id -- Select only for this Supplier