APPS.CS_TZ_GET_DETAILS_PVT dependencies on CS_INCIDENTS_ALL_B

Line 602: FROM cs_incidents_all_b a, jtf_tasks_b b

598:
599: -- Cursor to derive Task location type
600: CURSOR task_address_location_type IS
601: SELECT a.incident_location_id, a.incident_location_type
602: FROM cs_incidents_all_b a, jtf_tasks_b b
603: WHERE a.incident_id = b.source_object_id
604: AND b.source_object_type_code = 'SR'
605: AND b.task_id = p_task_id ;
606:

Line 651: FROM cs_incidents_all_b

647:
648: -- Cursor to derive time zone for contact entered on UI
649: CURSOR cont_pref_time_zone_id IS
650: SELECT time_zone_id
651: FROM cs_incidents_all_b
652: WHERE incident_id = p_incident_id;
653:
654: -- Cursor to derive time zone for Customer address
655: CURSOR customer_timezone IS

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

653:
654: -- Cursor to derive time zone for Customer address
655: CURSOR customer_timezone IS
656: SELECT b.timezone_id
657: FROM hz_party_sites a, hz_locations b, cs_incidents_all_b c
658: WHERE a.party_id = c.customer_id
659: AND a.identifying_address_flag = 'Y'
660: AND a.location_id = b.location_id
661: AND c.incident_id = p_incident_id ;

Line 666: FROM hz_contact_points a, cs_incidents_all_b b

662:
663: -- Cursor to derive time zone for Customer phone
664: CURSOR customer_cont_point_tz IS
665: SELECT a.timezone_id
666: FROM hz_contact_points a, cs_incidents_all_b b
667: WHERE a.owner_table_id = b.customer_id
668: AND a.contact_point_type = 'PHONE'
669: AND a.primary_flag = 'Y'
670: AND b.incident_id = p_incident_id ;