DBA Data[Home] [Help]

APPS.PO_HEADERS_SV9 dependencies on PO_RELEASES

Line 206: FROM po_releases

202: SELECT 'Y' INTO l_rel_exists
203: FROM DUAL
204: WHERE EXISTS(
205: SELECT 'release exist after the expiration date'
206: FROM po_releases
207: WHERE release_date > X_start_date
208: AND po_header_id = l_po_header_id);
209: EXCEPTION
210: WHEN NO_DATA_FOUND THEN

Line 309: FROM po_releases

305: SELECT 'Y' INTO l_rel_exists
306: FROM DUAL
307: WHERE EXISTS(
308: SELECT 'release exist after the expiration date'
309: FROM po_releases
310: WHERE release_date > X_start_date
311: AND po_header_id = l_po_header_id);
312: EXCEPTION
313: WHEN NO_DATA_FOUND THEN