APPS.CS_TZ_GET_DETAILS_PVT dependencies on HZ_LOCATIONS

Line 610: FROM hz_party_sites a, hz_locations b

606:
607: -- Cursor to derive Task time zone for party site
608: CURSOR task_party_site_timezone IS
609: SELECT b.timezone_id
610: FROM hz_party_sites a, hz_locations b
611: WHERE a.location_id = b.location_id
612: --AND a.identifying_address_flag = 'Y'
613: AND a.party_site_id = l_incident_location_id ;
614:

Line 618: FROM hz_locations

614:
615: -- Cursor to derive Task time zone for location
616: CURSOR task_location_timezone IS
617: SELECT timezone_id
618: FROM hz_locations
619: WHERE location_id = l_incident_location_id ;
620:
621: -- Cursor to derive time zone for technician
622: CURSOR technician_timezone IS

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

626:
627: -- Cursor to derive time zone for Primary Contact address
628: CURSOR contact_timezone IS
629: SELECT b.timezone_id
630: FROM hz_party_sites a, hz_locations b, cs_hz_sr_contact_points c
631: WHERE a.party_id = c.party_id
632: AND a.identifying_address_flag = 'Y'
633: AND c.primary_flag = 'Y'
634: AND a.location_id = b.location_id

Line 657: FROM hz_party_sites a, hz_locations b, cs_incidents_all_b c

653:
654: -- Cursor to derive time zone for Customer address
655: CURSOR customer_timezone IS
656: SELECT b.timezone_id
657: FROM hz_party_sites a, hz_locations b, cs_incidents_all_b c
658: WHERE a.party_id = c.customer_id
659: AND a.identifying_address_flag = 'Y'
660: AND a.location_id = b.location_id
661: AND c.incident_id = p_incident_id ;

Line 678: FROM hz_party_sites a, hz_locations b

674:
675: -- Cursor to derive time zone for party site
676: CURSOR f_incident_party_site_timezone IS
677: SELECT b.timezone_id
678: FROM hz_party_sites a, hz_locations b
679: WHERE a.location_id = b.location_id
680: --AND a.identifying_address_flag = 'Y'
681: AND a.party_site_id = p_incident_location_id ;
682:

Line 686: FROM hz_locations

682:
683: -- Cursor to derive time zone for location
684: CURSOR f_incident_location_timezone IS
685: SELECT timezone_id
686: FROM hz_locations
687: WHERE location_id = p_incident_location_id ;
688:
689: -- Cursor to derive time zone for Primary Contact address
690: CURSOR f_contact_timezone IS

Line 692: FROM hz_party_sites a, hz_locations b

688:
689: -- Cursor to derive time zone for Primary Contact address
690: CURSOR f_contact_timezone IS
691: SELECT b.timezone_id
692: FROM hz_party_sites a, hz_locations b
693: WHERE a.location_id = b.location_id
694: AND a.identifying_address_flag = 'Y'
695: AND a.party_id = p_contact_party_id ;
696:

Line 708: FROM hz_party_sites a, hz_locations b

704:
705: -- Cursor to derive time zone for Customer address
706: CURSOR f_customer_timezone IS
707: SELECT b.timezone_id
708: FROM hz_party_sites a, hz_locations b
709: WHERE a.location_id = b.location_id
710: AND a.identifying_address_flag = 'Y'
711: AND a.party_id = p_customer_id ;
712: