APPS.CSF_LF_PUB SQL Statements

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

Line: 124

   SELECT nvl(cscp.default_display_center.sdo_srid, 8307) srid
   FROM   csf_sdm_ctry_profiles cscp
   WHERE  cscp.default_display_center IS NOT NULL;

Line: 130

   SELECT SPATIAL_COUNTRY_NAME
   FROM CSF_SPATIAL_CTRY_MAPPINGS
   WHERE HR_COUNTRY_NAME = p_country;

Line: 275

    sql_stmt_str := 'SELECT nvl(cscp.default_display_center.sdo_srid, 8307) srid
                     FROM csf_sdm_ctry_profiles' || l_data_set_name || ' cscp
                     WHERE cscp.default_display_center IS NOT NULL';

Line: 405

    /* select roadsegment_geometry into segmentGeometry
    from csf_lf_roadsegments
    where roadSegment_id = x_segid; */

Line: 414

    sql_stmt_str := 'SELECT roadsegment_geometry into segmentGeometry
                     FROM csf_lf_roadsegments' || l_data_set_name||'
                     WHERE roadSegment_id = '|| x_segid;

Line: 550

 /* select time_zone into x_timezone
    from csf_lf_roadsegments
    where roadsegment_id = p_locus.sdo_ordinates(6); */

Line: 558

    sql_stmt_str := 'SELECT time_zone into x_timezone
                       FROM csf_lf_roadsegments'|| l_data_set_name||'
                      WHERE roadsegment_id = '|| p_locus.sdo_ordinates(6);