APPS.AST_OFL_TRANS_SIZES_PARAM SQL Statements

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

Line: 38

     select to_char(sysdate, 'DD-MON-YYYY') into v_date_time from dual;

Line: 55

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

Line: 78

     select grpd.group_id sgi,
            decode(grpd.group_id, grpd.parent_group_id,
            decode(topgrp.manager_flag, 'Y', grptl.group_name,
			    ' *'||grptl.group_name),
            decode(topgrp.manager_flag, 'Y',
            decode(grpd.immediate_parent_flag, 'Y',
				 '-'||grptl.group_name, '--'||grptl.group_name),
            decode(grpd.immediate_parent_flag, 'Y',
		  '  -'||grptl.group_name, '  --'||grptl.group_name))) name
     from jtf_rs_groups_denorm grpd,
          jtf_rs_groups_tl grptl,
       (select distinct grpb.group_id, rrb2.manager_flag
          from jtf_rs_groups_b grpb,
               jtf_rs_role_relations rrel2,
               jtf_rs_roles_b rrb2,
               jtf_rs_resource_extns rsc2,
               jtf_rs_group_members mem,
               fnd_user fnu
         where grpb.group_id = mem.group_id
           and trunc(sysdate) between grpb.start_date_active
           and nvl(grpb.end_date_active, trunc(sysdate))
           and rrb2.role_type_code in ('SALES','TELESALES')
           and (rrb2.manager_flag = 'Y' or rrb2.admin_flag = 'Y')
           and rrel2.role_id = rrb2.role_id
           and trunc(sysdate) between rrel2.start_date_active
           and nvl(rrel2.end_date_active, trunc(sysdate))
           and rrel2.role_resource_type = 'RS_GROUP_MEMBER'
           and rrel2.role_resource_id = mem.group_member_id
           and mem.resource_id = rsc2.resource_id
           and mem.delete_flag='N'
           and rsc2.source_id = fnu.employee_id
           and fnu.user_id = p_userid) topgrp
 where grptl.group_id = grpd.group_id
   and grpd.parent_group_id = topgrp.group_id
   and trunc(sysdate) between grpd.start_date_active
   and nvl(grpd.end_date_active, trunc(sysdate))
 order by 2 desc;

Line: 118

    select currency_code
    from fnd_currencies_vl
    where upper(enabled_flag) = 'Y'
    and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
                       and nvl(end_date_active, trunc(sysdate))
    order by 1;

Line: 162

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

Line: 163

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

Line: 164

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

Line: 165

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

Line: 166

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

Line: 167

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

Line: 229

       htp.p('Select Output Format');

Line: 231

       htp.p ('');

Line: 232

       htp.FormSelectOption('Excel');

Line: 233

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

Line: 234

       htp.FormSelectClose;

Line: 243

       htp.p ('');

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

       htp.FormSelectClose;

     htp.p ('');

Line: 257

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

Line: 262

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

Line: 266

     htp.FormSelectClose;

Line: 269

     htp.p ('');

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

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

       htp.FormSelectClose;

       htp.p ('');

Line: 291

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

Line: 295

       htp.FormSelectClose;

Line: 298

     htp.p ('');

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

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

     htp.FormSelectClose;

     htp.p ('');

Line: 318

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

Line: 322

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

Line: 326

       htp.FormSelectClose;

Line: 333

       htp.p ('');

       htp.FormSelectOption('Creation Dates',
                            cattributes => ' value= '||'ENTRY');

       htp.FormSelectOption('Close Dates',
                            cattributes => ' value= '||'CLOSE',
			                cselected => 'TRUE' );

       htp.FormSelectClose;

       htp.p ('');

Line: 348

           htp.FormSelectOption(rec_sales_group.name,cattributes => ' value= '||rec_sales_group.sgi);

Line: 351

       htp.FormSelectClose;

Line: 359

     htp.p ('');

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

            htp.FormSelectOption(rec_currencies.currency_code);

     htp.FormSelectClose;