DBA Data[Home] [Help]

APPS.AP_EXTENDED_WITHHOLDING_PKG dependencies on AP_TAX_CODES

Line 446: ,P_Tax_Name ap_tax_codes.name%TYPE

442: **************************************************************************/
443:
444: FUNCTION Check_With_Dis
445: (P_Invoice_Distribution_Id ap_invoice_distributions.invoice_distribution_id%TYPE
446: ,P_Tax_Name ap_tax_codes.name%TYPE
447: ,P_Global_Attribute2 ap_invoice_distributions.global_attribute2%TYPE
448: ,P_Global_Attribute3 ap_invoice_distributions.global_attribute3%TYPE
449: ) return Varchar2
450: IS

Line 459: ,ap_tax_codes apc

455: SELECT 'EXIST' Awt
456: FROM ap_invoice_distributions apid
457: ,jl_zz_ap_inv_dis_wh jid
458: ,jl_zz_ap_sup_awt_cd jsw
459: ,ap_tax_codes apc
460: WHERE apid.invoice_distribution_id = P_Invoice_Distribution_Id
461: AND apid.invoice_id = jid.invoice_id
462: AND apid.distribution_line_number= jid.distribution_line_number
463: AND jid.supp_awt_code_id = jsw.supp_awt_code_id