The following lines contain the word 'select', 'insert', 'update' or 'delete':
htp.p(' var s_day = objform.p_sd_date.selectedIndex;');
htp.p(' var s_month = objform.p_sm_date.selectedIndex;');
htp.p(' var s_year = objform.p_sy_date.selectedIndex;');
htp.p(' var e_day = objform.p_ed_date.selectedIndex;');
htp.p(' var e_month = objform.p_em_date.selectedIndex;');
htp.p(' var e_year = objform.p_ey_date.selectedIndex;');
htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK. ') ||
'', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');
select distinct ltrim(rtrim(ppf.last_name))||', ' ||ltrim(rtrim(ppf.first_name)) manager_name ,
ppf.person_id manager_person_id
from per_people_f ppf,
as_sales_groups asg
where asg.manager_person_id = ppf.person_id
and asg.enabled_flag = 'Y'
and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
and trunc(sysdate)<= nvl(asg.end_date_active,trunc(sysdate) )
order by ltrim(rtrim(ppf.last_name))||', ' ||ltrim(rtrim(ppf.first_name)) ;
htp.p('Select Output Format ');
htp.p ('
htp.FormSelectOption('Excel');
htp.FormSelectOption('HTML',cselected => 'TRUE');
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption(rec_get_manager.manager_name,cattributes => ' value= '||rec_get_manager.manager_person_id);
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption(day_data(i),
cattributes => ' value= '||day_data(i),
cselected => 'TRUE' );
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption('JAN',cselected => 'TRUE');
htp.FormSelectOption('FEB');
htp.FormSelectOption('MAR');
htp.FormSelectOption('APR');
htp.FormSelectOption('MAY');
htp.FormSelectOption('JUN');
htp.FormSelectOption('JUL');
htp.FormSelectOption('AUG');
htp.FormSelectOption('SEP');
htp.FormSelectOption('OCT');
htp.FormSelectOption('NOV');
htp.FormSelectOption('DEC');
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption(year_data(i),
cattributes => ' value= '||year_data(i));
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption(day_data(i),
cattributes => ' value= '||day_data(i),
cselected => 'TRUE' );
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption('JAN',cselected => 'TRUE');
htp.FormSelectOption('FEB');
htp.FormSelectOption('MAR');
htp.FormSelectOption('APR');
htp.FormSelectOption('MAY');
htp.FormSelectOption('JUN');
htp.FormSelectOption('JUL');
htp.FormSelectOption('AUG');
htp.FormSelectOption('SEP');
htp.FormSelectOption('OCT');
htp.FormSelectOption('NOV');
htp.FormSelectOption('DEC');
htp.FormSelectClose;
htp.p ('
htp.FormSelectOption(year_data(i),
cattributes => ' value= '||year_data(i));
htp.FormSelectClose;