APPS.CS_TZ_GET_DETAILS_PVT dependencies on HZ_CONTACT_POINTS

Line 576: FROM hz_contact_points a, cs_hz_sr_contact_points b

572:
573: -- Cursor to derive time zone for Primary Contact phone
574: CURSOR contact_cont_point_tz IS
575: SELECT a.timezone_id
576: FROM hz_contact_points a, cs_hz_sr_contact_points b
577: WHERE a.owner_table_id = b.party_id
578: AND a.contact_point_type = b.contact_point_type
579: AND b.contact_point_type = 'PHONE'
580: AND a.primary_flag = b.primary_flag

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 ;

Line 636: FROM hz_contact_points

632:
633: -- Cursor to derive time zone for Primary Contact phone
634: CURSOR f_contact_cont_point_tz IS
635: SELECT timezone_id
636: FROM hz_contact_points
637: WHERE contact_point_type = 'PHONE'
638: AND primary_flag = 'Y'
639: AND owner_table_id = p_contact_party_id ;
640:

Line 652: FROM hz_contact_points

648:
649: -- Cursor to derive time zone for Customer phone
650: CURSOR f_customer_cont_point_tz IS
651: SELECT timezone_id
652: FROM hz_contact_points
653: WHERE contact_point_type = 'PHONE'
654: AND primary_flag = 'Y'
655: AND owner_table_id = p_customer_id ;
656: