403: l_duplicate_row VARCHAR2(1);
404:
405: /* Cursor to Create unique ID for AAI row */
406: CURSOR create_unique_id IS
407: SELECT hxt_seqno.nextval
408: FROM sys.dual;
409: l_id NUMBER(15);
410:
411: BEGIN
659: AND effective_end_date = hr_general.end_of_time;
660:
661: /* Cursor to Create unique ID for AAI row */
662: /* CURSOR create_unique_id IS
663: SELECT hxt_seqno.nextval
664: FROM sys.dual;
665:
666: l_id NUMBER(15);
667: */