APPS.CS_TZ_GET_DETAILS_PVT dependencies on CS_HZ_SR_CONTACT_POINTS

Line 566: FROM hz_party_sites a, hz_locations b, cs_hz_sr_contact_points c

562:
563: -- Cursor to derive time zone for Primary Contact address
564: CURSOR contact_timezone IS
565: SELECT b.timezone_id
566: FROM hz_party_sites a, hz_locations b, cs_hz_sr_contact_points c
567: WHERE a.party_id = c.party_id
568: AND a.identifying_address_flag = 'Y'
569: AND c.primary_flag = 'Y'
570: AND a.location_id = b.location_id

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