279: SELECT
280: 'Y'
281: INTO L_DUPLICATES
282: FROM
283: DUAL
284: WHERE EXISTS (
285: SELECT
286: 'Duplicates exist in ap_invoices'
287: FROM
809: SELECT
810: PO_VENDOR_SITES_S.NEXTVAL
811: INTO NEW_VENDOR_SITE_ID
812: FROM
813: SYS.DUAL;
814: SELECT
815: COUNT(*)
816: INTO L_TARGET_PRIMARY_PAY_SITES
817: FROM