APPS.CS_TZ_GET_DETAILS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 538: FROM cs_incidents_all_b a, jtf_tasks_b b

534:
535: -- Cursor to derive Task location type
536: CURSOR task_address_location_type IS
537: SELECT a.incident_location_id, a.incident_location_type
538: FROM cs_incidents_all_b a, jtf_tasks_b b
539: WHERE a.incident_id = b.source_object_id
540: AND b.source_object_type_code = 'SR'
541: AND b.task_id = p_task_id ;
542:

Line 587: FROM cs_incidents_all_b

583:
584: -- Cursor to derive time zone for contact entered on UI
585: CURSOR cont_pref_time_zone_id IS
586: SELECT time_zone_id
587: FROM cs_incidents_all_b
588: WHERE incident_id = p_incident_id;
589:
590: -- Cursor to derive time zone for Customer address
591: CURSOR customer_timezone IS

Line 593: FROM hz_party_sites a, hz_locations b, cs_incidents_all_b c

589:
590: -- Cursor to derive time zone for Customer address
591: CURSOR customer_timezone IS
592: SELECT b.timezone_id
593: FROM hz_party_sites a, hz_locations b, cs_incidents_all_b c
594: WHERE a.party_id = c.customer_id
595: AND a.identifying_address_flag = 'Y'
596: AND a.location_id = b.location_id
597: AND c.incident_id = p_incident_id ;

Line 602: FROM hz_contact_points a, cs_incidents_all_b b

598:
599: -- Cursor to derive time zone for Customer phone
600: CURSOR customer_cont_point_tz IS
601: SELECT a.timezone_id
602: FROM hz_contact_points a, cs_incidents_all_b b
603: WHERE a.owner_table_id = b.customer_id
604: AND a.contact_point_type = 'PHONE'
605: AND a.primary_flag = 'Y'
606: AND b.incident_id = p_incident_id ;