APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on HZ_CONTACT_POINTS

Line 860: FROM hz_contact_points

856:
857: IF l_timezone_id IS NULL THEN
858: SELECT timezone_id
859: INTO l_timezone_id
860: FROM hz_contact_points
861: WHERE contact_point_type = 'PHONE'
862: AND primary_flag = 'Y'
863: AND contact_point_id = p_contact_point_id;
864: END IF;

Line 1766: FROM hz_contact_points

1762:
1763: -- Cursor to derive time zone for Primary Contact phone
1764: CURSOR Contact_cont_point_tz IS
1765: SELECT timezone_id
1766: FROM hz_contact_points
1767: WHERE contact_point_type = 'PHONE'
1768: AND primary_flag = 'Y'
1769: AND owner_table_id = p_contact_party_id ;
1770:

Line 1830: FROM hz_contact_points

1826:
1827: -- Cursor to derive time zone for Customer phone
1828: CURSOR Cur_Customer_Cont_Point_Tz IS
1829: SELECT timezone_id
1830: FROM hz_contact_points
1831: WHERE contact_point_type = 'PHONE'
1832: AND primary_flag = 'Y'
1833: AND owner_table_id = p_customer_id ;
1834: BEGIN