[Home] [Help]
3268: when no_data_found then
3269: null;
3270: end;
3271:
3272: -- Need to obtain the buyers from po_headers_archive and po_releases_archive
3273: -- for global buyer's need to get buyer name from per_employees_current_x
3274: if (l_document_type in ('PO', 'PA')) THEN
3275: -- there will be an entry in this table regardless of whether there is a revision
3276: -- or not
3286:
3287: else
3288: select full_name into l_buyer
3289: from per_all_people_f --
3290: where person_id = (select agent_id from po_headers_archive
3291: where po_header_id = to_number(l_po_header_id) and
3292: revision_num = 0)
3293: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3294: end if;
3302: begin
3303: if (l_po_revision > 0) then
3304: select full_name into l_revision_buyer
3305: from per_all_people_f --
3306: where person_id = (select agent_id from po_headers_archive
3307: where po_header_id = to_number(l_po_header_id) and
3308: revision_num = l_po_revision)
3309: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3310: end if;