APPS.CS_TZ_GET_DETAILS_PVT SQL Statements

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

Line: 537

    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: 545

    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: 553

    SELECT timezone_id
    FROM   hz_locations
    WHERE  location_id = l_incident_location_id ;

Line: 559

    SELECT time_zone
    FROM jtf_rs_resource_extns_vl
    WHERE resource_id = p_resource_id ;

Line: 565

    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: 575

    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: 586

    SELECT time_zone_id
    FROM   cs_incidents_all_b
    WHERE  incident_id = p_incident_id;

Line: 592

    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: 601

    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: 613

    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: 621

    SELECT timezone_id
    FROM   hz_locations
    WHERE  location_id = p_incident_location_id ;

Line: 627

    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: 635

    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: 643

    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: 651

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

Line: 659

    SELECT name
    FROM   fnd_timezones_vl
    WHERE  upgrade_tz_id = l_tz_id ;