APPS.AP_EXTENDED_WITHHOLDING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 178: P_Inv_Dist_Id IN ap_invoice_distributions_all.invoice_distribution_id%TYPE,

174: **************************************************************************/
175: PROCEDURE Ap_Ext_Withholding_Default
176: (P_Invoice_Id IN Number,
177: P_Inv_Line_Num IN Number, --Bug 4554163
178: P_Inv_Dist_Id IN ap_invoice_distributions_all.invoice_distribution_id%TYPE,
179: P_Calling_Module IN Varchar2, --Bug 4554163
180: P_Parent_Dist_ID IN Number,
181: P_Awt_Success OUT NOCOPY Varchar2)
182:

Line 445: (P_Invoice_Distribution_Id ap_invoice_distributions.invoice_distribution_id%TYPE

441: * *
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

Line 447: ,P_Global_Attribute2 ap_invoice_distributions.global_attribute2%TYPE

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
451: -------------------------------------------------------------------------

Line 448: ,P_Global_Attribute3 ap_invoice_distributions.global_attribute3%TYPE

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
451: -------------------------------------------------------------------------
452: -- Select 'EXIST' from jl_zz_ap_inv_dis_wh

Line 456: FROM ap_invoice_distributions apid

452: -- Select 'EXIST' from jl_zz_ap_inv_dis_wh
453: -------------------------------------------------------------------------
454: CURSOR Invoice_Dis_Withholdings IS
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