APPS.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on JL_ZZ_AP_AWT_TYPES

Line 283: FUNCTION Company_Agent (P_Awt_Type_Code jl_zz_ap_awt_types.awt_type_code%TYPE,

279: The Following function verify if the company is agent for a withholding type.
280: The function receive the Supplier Withholding Type as parameter.
281: ------------------------------------------------------------------------------------------------*/
282:
283: FUNCTION Company_Agent (P_Awt_Type_Code jl_zz_ap_awt_types.awt_type_code%TYPE,
284: P_Invoice_Id ap_invoices_all.invoice_id%TYPE)
285: return boolean is
286:
287: Cursor Company_Awt_Types (PC_Legal_Entity_ID xle_entity_profiles.legal_entity_id%TYPE)

Line 547: jl_zz_ap_awt_types awt

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
549: AND swt.wh_subject_flag = 'Y' -- Supp subject to the withholding tax type
550: AND swc.supp_awt_type_id = swt.supp_awt_type_id -- Join
551: AND swc.tax_id = tca.tax_id -- Join