APPS.CS_SERVICEREQUEST_PVT dependencies on HZ_CONTACT_POINTS

Line 747: -- : p_contact_point_id primary key to hz_contact_points

743: --============================================================================
744: -- PROCEDURE : set_time_zone PRIVATE
745: -- PARAMETERS: p_contact_party_id Contact party
746: -- : p_contact_point_type it could PHONE or EMAIL
747: -- : p_contact_point_id primary key to hz_contact_points
748: -- : p_incident_id primary key to incidents table
749: -- COMMENT : This procedure will determine timezone based on primary contact's
750: -- : phone or identifying address and update incidents table
751: -- : If no timezone is found then incidents table is not updated

Line 764: hz_contact_points

760: CURSOR c_phone_timezone IS
761: SELECT
762: timezone_id
763: FROM
764: hz_contact_points
765: WHERE contact_point_id = p_contact_point_id;
766:
767: CURSOR c_addr_timezone IS
768: SELECT