APPS.CS_TZ_GET_DETAILS_PVT SQL Statements

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

Line: 96

      Select timezone_code Into l_timezone_code
      From fnd_timezones_b
      Where upgrade_tz_id = l_end_tz_id;

Line: 99

          select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
          || to_number(substr(tz_offset(l_timezone_code),2,2))
          || decode(to_number(substr(tz_offset(l_timezone_code),5,2))/60,0,null,to_number(substr(tz_offset(l_timezone_code),5,2))/60))
      into l_e_GMT_dev
      from dual;

Line: 127

      Select timezone_code Into l_timezone_code
      From fnd_timezones_b
      Where upgrade_tz_id = l_start_tz_id;

Line: 131

      select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
          || to_number(substr(tz_offset(l_timezone_code),2,2))
          || decode(to_number(substr(tz_offset(l_timezone_code),5,2))/60,0,null,to_number(substr(tz_offset(l_timezone_code),5,2))/60))
      into l_s_GMT_dev
      from dual;

Line: 255

      Select timezone_code Into l_timezone_code
      From fnd_timezones_b
      Where upgrade_tz_id = l_start_tz_id;

Line: 259

      select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
          || to_number(substr(tz_offset(l_timezone_code),2,2))
          || decode(to_number(substr(tz_offset(l_timezone_code),5,2))/60,0,null,to_number(substr(tz_offset(l_timezone_code),5,2))/60))
      into l_s_GMT_dev
      from dual;

Line: 265

      Select timezone_code Into l_timezone_code
      From fnd_timezones_b
      Where upgrade_tz_id = l_end_tz_id;

Line: 269

      select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
          || to_number(substr(tz_offset(l_timezone_code),2,2))
          || decode(to_number(substr(tz_offset(l_timezone_code),5,2))/60,0,null,to_number(substr(tz_offset(l_timezone_code),5,2))/60))
      into l_e_GMT_dev
      from dual;

Line: 460

      Select timezone_code Into l_timezone_code
      From fnd_timezones_b
      Where upgrade_tz_id = l_start_tz_id;

Line: 464

      select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
          || to_number(substr(tz_offset(l_timezone_code),2,2))
          || decode(to_number(substr(tz_offset(l_timezone_code),5,2))/60,0,null,to_number(substr(tz_offset(l_timezone_code),5,2))/60))
      into l_s_GMT_dev
      from dual;

Line: 470

      Select timezone_code Into l_timezone_code
      From fnd_timezones_b
      Where upgrade_tz_id = l_end_tz_id;

Line: 474

      select to_number(decode(substr(tz_offset(l_timezone_code),1,1),'-','-')
          || to_number(substr(tz_offset(l_timezone_code),2,2))
          || decode(to_number(substr(tz_offset(l_timezone_code),5,2))/60,0,null,to_number(substr(tz_offset(l_timezone_code),5,2))/60))
      into l_e_GMT_dev
      from dual;

Line: 601

    SELECT a.incident_location_id, a.incident_location_type
    FROM  cs_incidents_all_b a, jtf_tasks_b b
    WHERE a.incident_id = b.source_object_id
      AND b.source_object_type_code = 'SR'
      AND b.task_id = p_task_id ;

Line: 609

    SELECT b.timezone_id
    FROM   hz_party_sites a, hz_locations b
    WHERE  a.location_id = b.location_id
      --AND  a.identifying_address_flag = 'Y'
      AND  a.party_site_id = l_incident_location_id ;

Line: 617

    SELECT timezone_id
    FROM   hz_locations
    WHERE  location_id = l_incident_location_id ;

Line: 623

    SELECT time_zone
    FROM jtf_rs_resource_extns_vl
    WHERE resource_id = p_resource_id ;

Line: 629

    SELECT b.timezone_id
    FROM   hz_party_sites a, hz_locations b, cs_hz_sr_contact_points c
    WHERE  a.party_id = c.party_id
      AND  a.identifying_address_flag = 'Y'
      AND  c.primary_flag = 'Y'
      AND  a.location_id = b.location_id
      AND  c.incident_id = p_incident_id ;

Line: 639

    SELECT a.timezone_id
    FROM   hz_contact_points a, cs_hz_sr_contact_points b
    WHERE  a.owner_table_id = b.party_id
      AND  a.contact_point_type = b.contact_point_type
      AND  b.contact_point_type = 'PHONE'
      AND  a.primary_flag = b.primary_flag
      AND  b.primary_flag = 'Y'
      AND  b.incident_id = p_incident_id ;

Line: 650

    SELECT time_zone_id
    FROM   cs_incidents_all_b
    WHERE  incident_id = p_incident_id;

Line: 656

    SELECT b.timezone_id
    FROM   hz_party_sites a, hz_locations b, cs_incidents_all_b c
    WHERE  a.party_id = c.customer_id
      AND  a.identifying_address_flag = 'Y'
      AND  a.location_id = b.location_id
      AND  c.incident_id = p_incident_id ;

Line: 665

    SELECT a.timezone_id
    FROM   hz_contact_points a, cs_incidents_all_b b
    WHERE  a.owner_table_id = b.customer_id
    AND    a.contact_point_type = 'PHONE'
    AND    a.primary_flag = 'Y'
    AND    b.incident_id = p_incident_id ;

Line: 677

    SELECT b.timezone_id
    FROM   hz_party_sites a, hz_locations b
    WHERE  a.location_id = b.location_id
      --AND  a.identifying_address_flag = 'Y'
      AND  a.party_site_id = p_incident_location_id ;

Line: 685

    SELECT timezone_id
    FROM   hz_locations
    WHERE  location_id = p_incident_location_id ;

Line: 691

    SELECT b.timezone_id
    FROM   hz_party_sites a, hz_locations b
    WHERE  a.location_id = b.location_id
      AND  a.identifying_address_flag = 'Y'
      AND  a.party_id = p_contact_party_id ;

Line: 699

    SELECT timezone_id
    FROM   hz_contact_points
    WHERE  contact_point_type = 'PHONE'
      AND  primary_flag = 'Y'
      AND  owner_table_id = p_contact_party_id ;

Line: 707

    SELECT b.timezone_id
    FROM   hz_party_sites a, hz_locations b
    WHERE  a.location_id = b.location_id
      AND  a.identifying_address_flag = 'Y'
      AND  a.party_id = p_customer_id ;

Line: 715

    SELECT timezone_id
    FROM   hz_contact_points
    WHERE  contact_point_type = 'PHONE'
      AND  primary_flag = 'Y'
      AND  owner_table_id = p_customer_id ;

Line: 723

    SELECT name
    FROM   fnd_timezones_vl
    WHERE  upgrade_tz_id = l_tz_id ;

Line: 1120

select timezone_code into l_tz_code from FND_TIMEZONES_VL where upgrade_tz_id = l_tx_id;