if NOT migration_util.table_exists('XA_10969_HPY1) THEN
			
migration_util.execute_immediate('CREATE TABLE XA_10969_HPY1 
(COMPANY VARCHAR2(3), 
 PAYGROUP VARCHAR2(3), 
 PAY_END_DT DATE,
 OFF_CYCLE VARCHAR2(1), 
 PAGE_NUM NUMBER(4),
 LINE_NUM NUMBER(2), 
 EMPLID VARCHAR2(11),
 PURGEABLE_FLAG CHAR(1), 
 STATS_DATE DATE,
 ORG_ID VARCHAR2(5), 
 ALL_PAGES_CONFIRMD NUMBER(31),
 ALL_EARNS_FINALIZD NUMBER(31), 
 APPLIMATION_JOB_ID NUMBER(38) NOT NULL)');	

end if;

if migration_util.table_exists('XA_10969_HPY1') THEN
		
migration_util.execute_immediate('INSERT INTO XA_10969_HPY1
(COMPANY, PAYGROUP, PAY_END_DT, OFF_CYCLE, PAGE_NUM, LINE_NUM, EMPLID, PURGEABLE_FLAG, STATS_DATE, ORG_ID, ALL_PAGES_CONFIRMD, ALL_EARNS_FINALIZD, APPLIMATION_JOB_ID) 
SELECT COMPANY, PAYGROUP, PAY_END_DT, OFF_CYCLE, PAGE_NUM, LINE_NUM, EMPLID, PURGEABLE_FLAG, STATS_DATE, ORG_ID, ALL_PAGES_CONFIRMD, ALL_EARNS_FINALIZD, APPLIMATION_JOB_ID FROM XA_797_HPY1');
		
end if;