APPS.AST_OFL_LEAD_ACC_PARAM SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

     select fnd_date.date_to_chardate(sysdate) into v_date_time from dual;

Line: 51

     htp.tableData( '' ||htf.bold( 'Please specify the criteria and select OK.  ') ||
                    '', calign => 'center', crowspan => '2', ccolspan => '110', cattributes => ' width=346');

Line: 105

       htp.p('    var s_day = objform.p_sd_date.selectedIndex;');

Line: 106

       htp.p('    var s_month = objform.p_sm_date.selectedIndex;');

Line: 107

       htp.p('    var s_year = objform.p_sy_date.selectedIndex;');

Line: 142

       htp.p('Select Output Format');

Line: 144

       htp.p ('');

Line: 145

       htp.FormSelectOption('Excel');

Line: 146

       htp.FormSelectOption('HTML',cselected => 'TRUE');

Line: 147

       htp.FormSelectClose;

Line: 155

       htp.p ('');

	           htp.FormSelectOption(day_data(i),
			cattributes => ' value= '||day_data(i),
			cselected => 'TRUE' );

       htp.FormSelectClose;

     htp.p ('');

Line: 169

               htp.FormSelectOption(lpad(to_char(i),2,'0'),
                   cattributes => ' value='||lpad(to_char(i),2,'0'),
                   cselected => 'TRUE' );

Line: 173

               htp.FormSelectOption(lpad(to_char(i),2,'0'),
                   cattributes => ' value='||lpad(to_char(i),2,'0'));

Line: 177

     htp.FormSelectClose;

Line: 180

     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 ('');

Line: 199

	           htp.FormSelectOption(year_data(i),
			cattributes => ' value= '||year_data(i));

Line: 202

       htp.FormSelectClose;