APPS.POA_OLTP_GENERIC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

select min(approved_date)
into app_date
from po_headers_archive_all poh
where poh.po_header_id = p_poh_id
and poh.approved_date >= p_creation_date;

Line: 49

select min(approved_date)
into app_date
from po_releases_archive_all por
where por.po_release_id = p_por_id
and por.approved_date >= p_creation_date;

Line: 73

select min(approved_date)
into app_date
from po_line_locations_archive_all pll
where pll.line_location_id = p_line_location_id
and pll.approved_date >= p_creation_date;