APPS.JTF_TERR_DEFINITION_PARAM_PVT SQL Statements

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

Line: 25

     select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;

Line: 41

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

Line: 64

    select -1 resource_id, 'ALL' resource_name
    from dual
 union
    select distinct resource_id, wf_notification.substitutespecialchars(resource_name) resource_name
    from jtf_terr_resources_v
    order by resource_name;

Line: 73

    select -1  qual_usg_id ,'ALL' seeded_qual_name
    from dual
 union
    select qual_usg_id , wf_notification.substitutespecialchars(usage) || ' - ' ||
                         wf_notification.substitutespecialchars(seeded_qual_name) seeded_qual_name
    from jtf_seeded_qual_usgs_v
    where enabled_flag = 'Y' and not (qual_type_id = -1001)
 order by seeded_qual_name;

Line: 107

       htp.p('Select Output Format');

Line: 109

       htp.p('');

Line: 110

       htp.FormSelectOption('Excel');

Line: 111

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

Line: 112

       htp.FormSelectClose;

Line: 118

       htp.p ('');

           htp.FormSelectOption(rec_salesrep.resource_name,cattributes => ' value= '||rec_salesrep.resource_id);

       htp.FormSelectClose;

       htp.p ('');

Line: 131

           htp.FormSelectOption(rec_qual.seeded_qual_name, cattributes => ' value= '||rec_qual.qual_usg_id);

Line: 134

       htp.FormSelectClose;