create table attn_tbl(
emp_no number,
attn_dt date);							 

create table v_leave_dtl(
emp_no number,
day date);

insert into attn_tbl values(1,to_date('01-SEP-09'));
insert into attn_tbl values(2,to_date('01-SEP-09'));
insert into attn_tbl values(3,to_date('01-SEP-09'));
insert into attn_tbl values(8,to_date('01-SEP-09'));
insert into attn_tbl values(1,to_date('02-SEP-09'));
insert into attn_tbl values(2,to_date('02-SEP-09'));
insert into attn_tbl values(3,to_date('02-SEP-09'));
insert into attn_tbl values(8,to_date('02-SEP-09'));
insert into attn_tbl values(1,to_date('03-SEP-09'));
insert into attn_tbl values(2,to_date('03-SEP-09'));
insert into attn_tbl values(3,to_date('03-SEP-09'));
insert into attn_tbl values(8,to_date('03-SEP-09'));
insert into attn_tbl values(1,to_date('04-SEP-09'));
insert into attn_tbl values(2,to_date('04-SEP-09'));
insert into attn_tbl values(3,to_date('04-SEP-09'));
insert into attn_tbl values(8,to_date('04-SEP-09'));
insert into attn_tbl values(1,to_date('05-SEP-09'));
insert into attn_tbl values(2,to_date('05-SEP-09'));
insert into attn_tbl values(3,to_date('05-SEP-09'));
insert into attn_tbl values(8,to_date('05-SEP-09'));
insert into attn_tbl values(1,to_date('06-SEP-09'));
insert into attn_tbl values(2,to_date('06-SEP-09'));
insert into attn_tbl values(3,to_date('06-SEP-09'));
insert into attn_tbl values(8,to_date('06-SEP-09'));
insert into attn_tbl values(1,to_date('07-SEP-09'));
insert into attn_tbl values(2,to_date('07-SEP-09'));
insert into attn_tbl values(3,to_date('07-SEP-09'));
insert into attn_tbl values(8,to_date('07-SEP-09'));
insert into attn_tbl values(1,to_date('08-SEP-09'));
insert into attn_tbl values(2,to_date('08-SEP-09'));
insert into attn_tbl values(3,to_date('08-SEP-09'));
insert into attn_tbl values(8,to_date('08-SEP-09'));
insert into attn_tbl values(1,to_date('09-SEP-09'));
insert into attn_tbl values(2,to_date('09-SEP-09'));
insert into attn_tbl values(3,to_date('09-SEP-09'));
insert into attn_tbl values(8,to_date('09-SEP-09'));
insert into attn_tbl values(1,to_date('10-SEP-09'));
insert into attn_tbl values(2,to_date('10-SEP-09'));
insert into attn_tbl values(3,to_date('10-SEP-09'));
insert into attn_tbl values(8,to_date('10-SEP-09'));
insert into attn_tbl values(1,to_date('11-SEP-09'));
insert into attn_tbl values(2,to_date('11-SEP-09'));
insert into attn_tbl values(3,to_date('11-SEP-09'));
insert into attn_tbl values(8,to_date('11-SEP-09'));
insert into attn_tbl values(1,to_date('12-SEP-09'));
insert into attn_tbl values(2,to_date('12-SEP-09'));
insert into attn_tbl values(3,to_date('12-SEP-09'));
insert into attn_tbl values(8,to_date('12-SEP-09'));
insert into attn_tbl values(1,to_date('13-SEP-09'));
insert into attn_tbl values(2,to_date('13-SEP-09'));
insert into attn_tbl values(3,to_date('13-SEP-09'));
insert into attn_tbl values(8,to_date('13-SEP-09'));
insert into attn_tbl values(1,to_date('14-SEP-09'));
insert into attn_tbl values(2,to_date('14-SEP-09'));
insert into attn_tbl values(3,to_date('14-SEP-09'));
insert into attn_tbl values(8,to_date('14-SEP-09'));
insert into attn_tbl values(1,to_date('15-SEP-09'));
insert into attn_tbl values(2,to_date('15-SEP-09'));
insert into attn_tbl values(3,to_date('15-SEP-09'));
insert into attn_tbl values(8,to_date('15-SEP-09'));
insert into attn_tbl values(1,to_date('16-SEP-09'));
insert into attn_tbl values(2,to_date('16-SEP-09'));
insert into attn_tbl values(3,to_date('16-SEP-09'));
insert into attn_tbl values(8,to_date('16-SEP-09'));
insert into attn_tbl values(1,to_date('17-SEP-09'));
insert into attn_tbl values(2,to_date('17-SEP-09'));
insert into attn_tbl values(3,to_date('17-SEP-09'));
insert into attn_tbl values(8,to_date('17-SEP-09'));
insert into attn_tbl values(1,to_date('18-SEP-09'));
insert into attn_tbl values(2,to_date('18-SEP-09'));
insert into attn_tbl values(3,to_date('18-SEP-09'));
insert into attn_tbl values(8,to_date('18-SEP-09'));
insert into attn_tbl values(1,to_date('19-SEP-09'));
insert into attn_tbl values(2,to_date('19-SEP-09'));
insert into attn_tbl values(3,to_date('19-SEP-09'));
insert into attn_tbl values(8,to_date('19-SEP-09'));
insert into attn_tbl values(1,to_date('20-SEP-09'));
insert into attn_tbl values(2,to_date('20-SEP-09'));
insert into attn_tbl values(3,to_date('20-SEP-09'));
insert into attn_tbl values(8,to_date('20-SEP-09'));
insert into attn_tbl values(1,to_date('21-SEP-09'));
insert into attn_tbl values(2,to_date('21-SEP-09'));
insert into attn_tbl values(3,to_date('21-SEP-09'));
insert into attn_tbl values(8,to_date('21-SEP-09'));
insert into attn_tbl values(1,to_date('22-SEP-09'));
insert into attn_tbl values(2,to_date('22-SEP-09'));
insert into attn_tbl values(3,to_date('22-SEP-09'));
insert into attn_tbl values(8,to_date('22-SEP-09'));
insert into attn_tbl values(1,to_date('23-SEP-09'));
insert into attn_tbl values(2,to_date('23-SEP-09'));
insert into attn_tbl values(3,to_date('23-SEP-09'));
insert into attn_tbl values(8,to_date('23-SEP-09'));
insert into attn_tbl values(1,to_date('24-SEP-09'));
insert into attn_tbl values(2,to_date('24-SEP-09'));
insert into attn_tbl values(3,to_date('24-SEP-09'));
insert into attn_tbl values(8,to_date('24-SEP-09'));
insert into attn_tbl values(1,to_date('25-SEP-09'));
insert into attn_tbl values(2,to_date('25-SEP-09'));
insert into attn_tbl values(3,to_date('25-SEP-09'));
insert into attn_tbl values(8,to_date('25-SEP-09'));
insert into attn_tbl values(1,to_date('26-SEP-09'));
insert into attn_tbl values(2,to_date('26-SEP-09'));
insert into attn_tbl values(3,to_date('26-SEP-09'));
insert into attn_tbl values(8,to_date('26-SEP-09'));
insert into attn_tbl values(1,to_date('27-SEP-09'));
insert into attn_tbl values(2,to_date('27-SEP-09'));
insert into attn_tbl values(3,to_date('27-SEP-09'));
insert into attn_tbl values(8,to_date('27-SEP-09'));
insert into attn_tbl values(1,to_date('28-SEP-09'));
insert into attn_tbl values(2,to_date('28-SEP-09'));
insert into attn_tbl values(3,to_date('28-SEP-09'));
insert into attn_tbl values(8,to_date('28-SEP-09'));
insert into attn_tbl values(1,to_date('29-SEP-09'));
insert into attn_tbl values(2,to_date('29-SEP-09'));
insert into attn_tbl values(3,to_date('29-SEP-09'));
insert into attn_tbl values(8,to_date('29-SEP-09'));
insert into attn_tbl values(1,to_date('30-SEP-09'));
insert into attn_tbl values(2,to_date('30-SEP-09'));
insert into attn_tbl values(3,to_date('30-SEP-09'));
insert into attn_tbl values(8,to_date('30-SEP-09'));
insert into attn_tbl values(1,to_date('01-OCT-09'));
insert into attn_tbl values(2,to_date('01-OCT-09'));
insert into attn_tbl values(3,to_date('01-OCT-09'));
insert into attn_tbl values(8,to_date('01-OCT-09'));
insert into attn_tbl values(1,to_date('02-OCT-09'));
insert into attn_tbl values(2,to_date('02-OCT-09'));
insert into attn_tbl values(3,to_date('02-OCT-09'));
insert into attn_tbl values(8,to_date('02-OCT-09'));
insert into attn_tbl values(1,to_date('03-OCT-09'));
insert into attn_tbl values(2,to_date('03-OCT-09'));
insert into attn_tbl values(3,to_date('03-OCT-09'));
insert into attn_tbl values(8,to_date('03-OCT-09'));
insert into attn_tbl values(1,to_date('04-OCT-09'));
insert into attn_tbl values(2,to_date('04-OCT-09'));
insert into attn_tbl values(3,to_date('04-OCT-09'));
insert into attn_tbl values(8,to_date('04-OCT-09'));
insert into attn_tbl values(1,to_date('05-OCT-09'));
insert into attn_tbl values(2,to_date('05-OCT-09'));
insert into attn_tbl values(3,to_date('05-OCT-09'));
insert into attn_tbl values(8,to_date('05-OCT-09'));
insert into attn_tbl values(1,to_date('06-OCT-09'));
insert into attn_tbl values(2,to_date('06-OCT-09'));
insert into attn_tbl values(3,to_date('06-OCT-09'));
insert into attn_tbl values(8,to_date('06-OCT-09'));
insert into attn_tbl values(1,to_date('07-OCT-09'));
insert into attn_tbl values(2,to_date('07-OCT-09'));
insert into attn_tbl values(3,to_date('07-OCT-09'));
insert into attn_tbl values(8,to_date('07-OCT-09'));
insert into attn_tbl values(1,to_date('08-OCT-09'));
insert into attn_tbl values(2,to_date('08-OCT-09'));
insert into attn_tbl values(3,to_date('08-OCT-09'));
insert into attn_tbl values(8,to_date('08-OCT-09'));
insert into attn_tbl values(1,to_date('09-OCT-09'));
insert into attn_tbl values(2,to_date('09-OCT-09'));
insert into attn_tbl values(3,to_date('09-OCT-09'));
insert into attn_tbl values(8,to_date('09-OCT-09'));
insert into attn_tbl values(1,to_date('10-OCT-09'));
insert into attn_tbl values(2,to_date('10-OCT-09'));
insert into attn_tbl values(3,to_date('10-OCT-09'));
insert into attn_tbl values(8,to_date('10-OCT-09'));
insert into attn_tbl values(1,to_date('11-OCT-09'));
insert into attn_tbl values(2,to_date('11-OCT-09'));
insert into attn_tbl values(3,to_date('11-OCT-09'));
insert into attn_tbl values(8,to_date('11-OCT-09'));
insert into attn_tbl values(1,to_date('12-OCT-09'));
insert into attn_tbl values(2,to_date('12-OCT-09'));
insert into attn_tbl values(3,to_date('12-OCT-09'));
insert into attn_tbl values(8,to_date('12-OCT-09'));
insert into attn_tbl values(1,to_date('13-OCT-09'));
insert into attn_tbl values(2,to_date('13-OCT-09'));
insert into attn_tbl values(3,to_date('13-OCT-09'));
insert into attn_tbl values(8,to_date('13-OCT-09'));
insert into attn_tbl values(1,to_date('14-OCT-09'));
insert into attn_tbl values(2,to_date('14-OCT-09'));
insert into attn_tbl values(3,to_date('14-OCT-09'));
insert into attn_tbl values(8,to_date('14-OCT-09'));
insert into attn_tbl values(1,to_date('15-OCT-09'));
insert into attn_tbl values(2,to_date('15-OCT-09'));
insert into attn_tbl values(3,to_date('15-OCT-09'));
insert into attn_tbl values(8,to_date('15-OCT-09'));
insert into attn_tbl values(1,to_date('16-OCT-09'));
insert into attn_tbl values(2,to_date('16-OCT-09'));
insert into attn_tbl values(3,to_date('16-OCT-09'));
insert into attn_tbl values(8,to_date('16-OCT-09'));
insert into attn_tbl values(1,to_date('17-OCT-09'));
insert into attn_tbl values(2,to_date('17-OCT-09'));
insert into attn_tbl values(3,to_date('17-OCT-09'));
insert into attn_tbl values(8,to_date('17-OCT-09'));
insert into attn_tbl values(1,to_date('18-OCT-09'));
insert into attn_tbl values(2,to_date('18-OCT-09'));
insert into attn_tbl values(3,to_date('18-OCT-09'));
insert into attn_tbl values(8,to_date('18-OCT-09'));
insert into attn_tbl values(1,to_date('19-OCT-09'));
insert into attn_tbl values(2,to_date('19-OCT-09'));
insert into attn_tbl values(3,to_date('19-OCT-09'));
insert into attn_tbl values(8,to_date('19-OCT-09'));
insert into attn_tbl values(1,to_date('20-OCT-09'));
insert into attn_tbl values(2,to_date('20-OCT-09'));
insert into attn_tbl values(3,to_date('20-OCT-09'));
insert into attn_tbl values(8,to_date('20-OCT-09'));
insert into attn_tbl values(1,to_date('21-OCT-09'));
insert into attn_tbl values(2,to_date('21-OCT-09'));
insert into attn_tbl values(3,to_date('21-OCT-09'));
insert into attn_tbl values(8,to_date('21-OCT-09'));
insert into attn_tbl values(1,to_date('22-OCT-09'));
insert into attn_tbl values(2,to_date('22-OCT-09'));
insert into attn_tbl values(3,to_date('22-OCT-09'));
insert into attn_tbl values(8,to_date('22-OCT-09'));
insert into attn_tbl values(1,to_date('23-OCT-09'));
insert into attn_tbl values(2,to_date('23-OCT-09'));
insert into attn_tbl values(3,to_date('23-OCT-09'));
insert into attn_tbl values(8,to_date('23-OCT-09'));
insert into attn_tbl values(1,to_date('24-OCT-09'));
insert into attn_tbl values(2,to_date('24-OCT-09'));
insert into attn_tbl values(3,to_date('24-OCT-09'));
insert into attn_tbl values(8,to_date('24-OCT-09'));
insert into attn_tbl values(1,to_date('25-OCT-09'));
insert into attn_tbl values(2,to_date('25-OCT-09'));
insert into attn_tbl values(3,to_date('25-OCT-09'));
insert into attn_tbl values(8,to_date('25-OCT-09'));
insert into attn_tbl values(1,to_date('26-OCT-09'));
insert into attn_tbl values(2,to_date('26-OCT-09'));
insert into attn_tbl values(3,to_date('26-OCT-09'));
insert into attn_tbl values(8,to_date('26-OCT-09'));
insert into attn_tbl values(1,to_date('27-OCT-09'));
insert into attn_tbl values(2,to_date('27-OCT-09'));
insert into attn_tbl values(3,to_date('27-OCT-09'));
insert into attn_tbl values(8,to_date('27-OCT-09'));
insert into attn_tbl values(1,to_date('28-OCT-09'));
insert into attn_tbl values(2,to_date('28-OCT-09'));
insert into attn_tbl values(3,to_date('28-OCT-09'));
insert into attn_tbl values(1,to_date('29-OCT-09'));
insert into attn_tbl values(2,to_date('29-OCT-09'));
insert into attn_tbl values(3,to_date('29-OCT-09'));
insert into attn_tbl values(1,to_date('30-OCT-09'));
insert into attn_tbl values(2,to_date('30-OCT-09'));
insert into attn_tbl values(3,to_date('30-OCT-09'));
insert into attn_tbl values(1,to_date('31-OCT-09'));
insert into attn_tbl values(2,to_date('31-OCT-09'));
insert into attn_tbl values(3,to_date('31-OCT-09'));

insert into v_leave_dtl values(8,to_date('28-OCT-09'));
insert into v_leave_dtl values(8,to_date('29-OCT-09'));
insert into v_leave_dtl values(8,to_date('30-OCT-09'));
insert into v_leave_dtl values(8,to_date('31-OCT-09'));