APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on AP_INVOICES

Line 2745: (P_Invoice_Id ap_invoices.invoice_id%TYPE

2741: * *
2742: **************************************************************************/
2743:
2744: FUNCTION Validate_Multiple_Bal_Seg
2745: (P_Invoice_Id ap_invoices.invoice_id%TYPE
2746: ) return Varchar2
2747: IS
2748:
2749: t_bal_seg varchar2(200);

Line 2835: (P_Invoice_Id ap_invoices.invoice_id%TYPE

2831: * *
2832: **************************************************************************/
2833:
2834: FUNCTION Validate_Mult_BS_GateWay
2835: (P_Invoice_Id ap_invoices.invoice_id%TYPE
2836: ) return Varchar2
2837: IS
2838:
2839: t_bal_seg varchar2(200);

Line 2861: ap_invoices_interface aii

2857: SELECT distinct atc.name, atc.tax_code_combination_id
2858: FROM jl_zz_ap_sup_awt_cd jsw,
2859: jl_zz_ap_supp_awt_types jst,
2860: ap_tax_codes atc,
2861: ap_invoices_interface aii
2862: WHERE aii.invoice_id = P_Invoice_id
2863: AND jst.vendor_id = aii.vendor_id
2864: AND jst.supp_awt_type_id = jsw.supp_awt_type_id
2865: AND atc.tax_id = jsw.tax_id

Line 3068: FROM ap_invoices ai,

3064: -- Obtains cumulative supplier exemption amount to day for a given period
3065: --------------------------------------------------------------------------
3066: SELECT NVL(sum(to_number(aid.global_attribute5)),0)
3067: INTO l_exemption_amount
3068: FROM ap_invoices ai,
3069: ap_invoice_distributions aid
3070: WHERE ai.vendor_id = P_Vendor_Id
3071: AND ai.invoice_id = aid.invoice_id
3072: AND trunc(aid.accounting_date) >= l_start_date