APPS.AP_PERIOD_CLOSE_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 1708: FROM PO_LINE_LOCATIONS_ALL PLL,

1704:
1705: UPDATE po_headers_all POH
1706: SET POH.closed_date = g_sweep_to_date
1707: WHERE po_header_id in (SELECT PLL.PO_HEADER_ID
1708: FROM PO_LINE_LOCATIONS_ALL PLL,
1709: PO_DISTRIBUTIONS_ALL PD,
1710: AP_PERIOD_CLOSE_EXCPS_GT GT
1711: WHERE PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
1712: AND PD.PO_DISTRIBUTION_ID = GT.PO_DISTRIBUTION_ID

Line 1726: UPDATE po_line_locations_all

1722:
1723: debug ('update_po_close_date: total records updated in po_headers_all:'||sql%rowcount);
1724:
1725:
1726: UPDATE po_line_locations_all
1727: SET closed_date = g_sweep_to_date
1728: WHERE line_location_id in (SELECT PLL.LINE_LOCATION_ID
1729: FROM PO_LINE_LOCATIONS_ALL PLL,
1730: PO_DISTRIBUTIONS_ALL PD,

Line 1729: FROM PO_LINE_LOCATIONS_ALL PLL,

1725:
1726: UPDATE po_line_locations_all
1727: SET closed_date = g_sweep_to_date
1728: WHERE line_location_id in (SELECT PLL.LINE_LOCATION_ID
1729: FROM PO_LINE_LOCATIONS_ALL PLL,
1730: PO_DISTRIBUTIONS_ALL PD,
1731: AP_PERIOD_CLOSE_EXCPS_GT GT
1732: WHERE PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
1733: AND PD.PO_DISTRIBUTION_ID = GT.PO_DISTRIBUTION_ID

Line 1742: debug ('update_po_close_date: total records updated in po_line_locations_all:'||sql%rowcount);

1738: AND PLL.CLOSED_DATE < g_sweep_to_date )
1739: GROUP BY PLL.LINE_LOCATION_ID, GT.PO_DISTRIBUTION_ID
1740: HAVING SUM(GT.AMOUNT) > 0);
1741:
1742: debug ('update_po_close_date: total records updated in po_line_locations_all:'||sql%rowcount);
1743:
1744: return TRUE;
1745:
1746: exception