APPS.JL_ZZ_AP_WITHHOLDING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 1506: from ap_invoice_distributions

1502: -- Bug 7491394: ERV changes start
1503: -----------------------------------
1504: select line_type_lookup_code, related_id
1505: into l_line_type, l_related_id
1506: from ap_invoice_distributions
1507: where invoice_distribution_id = P_Tab_Withhold(i).invoice_distribution_id;
1508:
1509: IF l_line_type = 'ERV' THEN
1510: l_awt_related_id := l_related_id;

Line 1887: -- l_dist_line_num ap_invoice_distributions.invoice_distribution_id%TYPE;

1883: ------------------------------
1884: l_parent_dist_num Varchar2(100);
1885:
1886: -- Bug 4559478
1887: -- l_dist_line_num ap_invoice_distributions.invoice_distribution_id%TYPE;
1888: l_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1889:
1890: l_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
1891: l_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;

Line 1888: l_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;

1884: l_parent_dist_num Varchar2(100);
1885:
1886: -- Bug 4559478
1887: -- l_dist_line_num ap_invoice_distributions.invoice_distribution_id%TYPE;
1888: l_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1889:
1890: l_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
1891: l_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1892: l_debug_info Varchar2(300);

Line 1890: l_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;

1886: -- Bug 4559478
1887: -- l_dist_line_num ap_invoice_distributions.invoice_distribution_id%TYPE;
1888: l_inv_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1889:
1890: l_po_distribution_id ap_invoice_distributions.po_distribution_id%TYPE;
1891: l_ship_to_location_id po_line_locations.ship_to_location_id%TYPE;
1892: l_debug_info Varchar2(300);
1893: l_calling_sequence Varchar2(2000);
1894: v_country_code Varchar2(100);

Line 1918: FROM ap_invoice_distributions apid

1914: IS
1915: SELECT apid.invoice_distribution_id,
1916: apid.po_distribution_id,
1917: apid.global_attribute20 -- What is gdf20?
1918: FROM ap_invoice_distributions apid
1919: WHERE apid.invoice_id = P_Credit_Id
1920: AND apid.invoice_line_number = P_Inv_Line_Num;
1921: */
1922:

Line 1962: -- distribution lines created in ap_invoice_distributions

1958: EXIT WHEN c_distributions%NOTFOUND;
1959: */
1960: ---------------------------------------------------------------
1961: -- Creates lines in JL_ZZ_AP_INV_DIS_WH_ALL table for the
1962: -- distribution lines created in ap_invoice_distributions
1963: ---------------------------------------------------------------
1964: IF (P_Parent_Dist_ID IS NOT NULL) THEN
1965:
1966: ----------------------------------------------------------

Line 2027: UPDATE ap_invoice_distributions

2023: -----------------------------------------------------------
2024: -- Updates the distribution line to hold ship to location
2025: -- for defaulting the tax names
2026: -----------------------------------------------------------
2027: UPDATE ap_invoice_distributions
2028: SET
2029: -- global_attribute3 = l_ship_to_location_id,
2030: global_attribute_category = decode(v_country_code,'AR','JL.AR.APXINWKB.DISTRIBUTIONS',
2031: 'CO','JL.CO.APXINWKB.DISTRIBUTIONS','')

Line 2712: -- Cursor to get CCID from AP_Invoice_Distributions_ID

2708: counter number :=1 ;
2709:
2710:
2711: ----------------------------------------------------------------------
2712: -- Cursor to get CCID from AP_Invoice_Distributions_ID
2713: ----------------------------------------------------------------------
2714: CURSOR Bal_Seg IS
2715: SELECT dist_code_combination_id
2716: FROM ap_invoice_distributions

Line 2716: FROM ap_invoice_distributions

2712: -- Cursor to get CCID from AP_Invoice_Distributions_ID
2713: ----------------------------------------------------------------------
2714: CURSOR Bal_Seg IS
2715: SELECT dist_code_combination_id
2716: FROM ap_invoice_distributions
2717: WHERE invoice_id = P_Invoice_id
2718: -- added recently
2719: AND NVL(REVERSAL_FLAG,'N') <> 'Y';
2720:

Line 2804: -- Cursor to get CCID from AP_Invoice_Distributions_ID

2800: Pre_Bal varchar2(200);
2801: counter number :=1 ;
2802:
2803: ----------------------------------------------------------------------
2804: -- Cursor to get CCID from AP_Invoice_Distributions_ID
2805: ----------------------------------------------------------------------
2806: CURSOR Bal_Seg IS
2807: SELECT dist_code_combination_id
2808: FROM ap_invoice_lines_interface

Line 3027: ap_invoice_distributions aid

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
3031: AND trunc(aid.accounting_date) <= l_end_date