APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on AP_INVOICES

Line 2700: (P_Invoice_Id ap_invoices.invoice_id%TYPE

2696: * *
2697: **************************************************************************/
2698:
2699: FUNCTION Validate_Multiple_Bal_Seg
2700: (P_Invoice_Id ap_invoices.invoice_id%TYPE
2701: ) return Varchar2
2702: IS
2703:
2704: t_bal_seg varchar2(200);

Line 2793: (P_Invoice_Id ap_invoices.invoice_id%TYPE

2789: * *
2790: **************************************************************************/
2791:
2792: FUNCTION Validate_Mult_BS_GateWay
2793: (P_Invoice_Id ap_invoices.invoice_id%TYPE
2794: ) return Varchar2
2795: IS
2796:
2797: t_bal_seg varchar2(200);

Line 2819: ap_invoices_interface aii

2815: SELECT distinct atc.name, atc.tax_code_combination_id
2816: FROM jl_zz_ap_sup_awt_cd jsw,
2817: jl_zz_ap_supp_awt_types jst,
2818: ap_tax_codes atc,
2819: ap_invoices_interface aii
2820: WHERE aii.invoice_id = P_Invoice_id
2821: AND jst.vendor_id = aii.vendor_id
2822: AND jst.supp_awt_type_id = jsw.supp_awt_type_id
2823: AND atc.tax_id = jsw.tax_id

Line 3026: FROM ap_invoices ai,

3022: -- Obtains cumulative supplier exemption amount to day for a given period
3023: --------------------------------------------------------------------------
3024: SELECT NVL(sum(to_number(aid.global_attribute5)),0)
3025: INTO l_exemption_amount
3026: FROM ap_invoices ai,
3027: ap_invoice_distributions aid
3028: WHERE ai.vendor_id = P_Vendor_Id
3029: AND ai.invoice_id = aid.invoice_id
3030: AND trunc(aid.accounting_date) >= l_start_date