APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on JL_ZZ_AP_INV_DIS_WH

Line 2011: -- Creates lines in JL_ZZ_AP_INV_DIS_WH_ALL table for the

2007: l_parent_dist_num; -- ap_dist.gdf20
2008: EXIT WHEN c_distributions%NOTFOUND;
2009: */
2010: ---------------------------------------------------------------
2011: -- Creates lines in JL_ZZ_AP_INV_DIS_WH_ALL table for the
2012: -- distribution lines created in ap_invoice_distributions
2013: ---------------------------------------------------------------
2014: IF (P_Parent_Dist_ID IS NOT NULL) THEN
2015:

Line 2019: INSERT INTO jl_zz_ap_inv_dis_wh (

2015:
2016: ----------------------------------------------------------
2017: -- Copies the tax names from the parent distribution line
2018: ----------------------------------------------------------
2019: INSERT INTO jl_zz_ap_inv_dis_wh (
2020: inv_distrib_awt_id
2021: ,invoice_id
2022: -- Bug 4559478
2023: ,invoice_distribution_id

Line 2033: jl_zz_ap_inv_dis_wh_s.nextval

2029: ,last_update_date
2030: ,last_update_login
2031: )
2032: SELECT
2033: jl_zz_ap_inv_dis_wh_s.nextval
2034: ,P_Credit_Id
2035: ,P_distribution_id
2036: -- Bug 4559478 : -99 for distribution_line_number
2037: ,-99

Line 2045: jl_zz_ap_inv_dis_wh jlid

2041: ,v_last_update_by
2042: ,sysdate
2043: ,v_last_update_login
2044: FROM
2045: jl_zz_ap_inv_dis_wh jlid
2046: WHERE jlid.invoice_distribution_id = P_Parent_Dist_ID
2047: AND jlid.invoice_id = P_Invoice_Id;
2048:
2049:

Line 2769: FROM jl_zz_ap_inv_dis_wh jid,

2765: -- Cursor to get the distinct tax codes for the given invoice
2766: ----------------------------------------------------------------------
2767: CURSOR tax_code IS
2768: SELECT distinct atc.name, atc.tax_code_combination_id
2769: FROM jl_zz_ap_inv_dis_wh jid,
2770: jl_zz_ap_sup_awt_cd jsw,
2771: ap_tax_codes atc
2772: WHERE jid.invoice_id = P_Invoice_Id
2773: AND jsw.supp_awt_code_id = jid.supp_awt_code_id