APPS.CS_TZ_GET_DETAILS_PVT dependencies on HZ_CONTACT_POINTS

Line 640: FROM hz_contact_points a, cs_hz_sr_contact_points b

636:
637: -- Cursor to derive time zone for Primary Contact phone
638: CURSOR contact_cont_point_tz IS
639: SELECT a.timezone_id
640: FROM hz_contact_points a, cs_hz_sr_contact_points b
641: WHERE a.owner_table_id = b.party_id
642: AND a.contact_point_type = b.contact_point_type
643: AND b.contact_point_type = 'PHONE'
644: AND a.primary_flag = b.primary_flag

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 ;

Line 700: FROM hz_contact_points

696:
697: -- Cursor to derive time zone for Primary Contact phone
698: CURSOR f_contact_cont_point_tz IS
699: SELECT timezone_id
700: FROM hz_contact_points
701: WHERE contact_point_type = 'PHONE'
702: AND primary_flag = 'Y'
703: AND owner_table_id = p_contact_party_id ;
704:

Line 716: FROM hz_contact_points

712:
713: -- Cursor to derive time zone for Customer phone
714: CURSOR f_customer_cont_point_tz IS
715: SELECT timezone_id
716: FROM hz_contact_points
717: WHERE contact_point_type = 'PHONE'
718: AND primary_flag = 'Y'
719: AND owner_table_id = p_customer_id ;
720: