APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on AP_TAX_CODES

Line 425: * 3. Associated global attributes (from AP_TAX_CODES) *

421: * Purpose : Obtains all the information associated to the current *
422: * tax name and for a particular supplier: *
423: * 1. Minimum taxable base amount *
424: * 2. Minimum withheld amount *
425: * 3. Associated global attributes (from AP_TAX_CODES) *
426: * 4. Supplier exemptions *
427: * *
428: **************************************************************************/
429: PROCEDURE Initialize_Withholding_Name

Line 505: FROM ap_tax_codes

501: l_glattr15,
502: l_glattr16,
503: l_glattr17,
504: l_glattr18
505: FROM ap_tax_codes
506: WHERE tax_id = P_Tax_Id;
507:
508: --------------------------
509: -- Sets common attributes

Line 2728: ap_tax_codes atc

2724: CURSOR tax_code IS
2725: SELECT distinct atc.name, atc.tax_code_combination_id
2726: FROM jl_zz_ap_inv_dis_wh jid,
2727: jl_zz_ap_sup_awt_cd jsw,
2728: ap_tax_codes atc
2729: WHERE jid.invoice_id = P_Invoice_Id
2730: AND jsw.supp_awt_code_id = jid.supp_awt_code_id
2731: AND atc.tax_id = jsw.tax_id;
2732:

Line 2818: ap_tax_codes atc,

2814: CURSOR tax_code IS
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

Line 3012: FROM ap_tax_codes

3008: -- Obtains start and end date for a given period
3009: -------------------------------------------------
3010: SELECT Tax_Id
3011: INTO l_tax_id
3012: FROM ap_tax_codes
3013: WHERE name = P_Tax_Name;
3014:
3015: -- Debug Information
3016: IF (DEBUG_Var = 'Y') THEN