DBA Data[Home] [Help]

APPS.JTF_TERR_CHANGES_PARAM_PVT SQL Statements

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

Line: 36

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

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

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

       htp.p('    var e_day = objform.p_ed_date.selectedIndex;');
Line: 40

       htp.p('    var e_month = objform.p_em_date.selectedIndex;');
Line: 41

       htp.p('    var e_year = objform.p_ey_date.selectedIndex;');
Line: 106

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

   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)) ;
Line: 181

       htp.p('Select Output Format');
Line: 183

       htp.p ('');
Line: 195

           htp.FormSelectOption(rec_get_manager.manager_name,cattributes => ' value= '||rec_get_manager.manager_person_id);
Line: 197

     htp.FormSelectClose;
Line: 205

        htp.p ('');
Line: 216

        htp.FormSelectOption('JAN',cselected => 'TRUE');
Line: 217

        htp.FormSelectOption('FEB');
Line: 218

        htp.FormSelectOption('MAR');
Line: 219

        htp.FormSelectOption('APR');
Line: 220

        htp.FormSelectOption('MAY');
Line: 221

        htp.FormSelectOption('JUN');
Line: 222

        htp.FormSelectOption('JUL');
Line: 223

        htp.FormSelectOption('AUG');
Line: 224

        htp.FormSelectOption('SEP');
Line: 225

        htp.FormSelectOption('OCT');
Line: 226

        htp.FormSelectOption('NOV');
Line: 227

        htp.FormSelectOption('DEC');
Line: 228

        htp.FormSelectClose;
Line: 230

        htp.p ('');
Line: 247

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

        htp.FormSelectClose;
Line: 254

        htp.p ('');
Line: 273

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

        htp.FormSelectClose;