APPS.HZ_DNBUI_PVT dependencies on HZ_PARTY_SITES

Line 602: from HZ_LOCATIONS loc, HZ_PARTY_SITES ps

598: END IF;
599:
600: select loc.location_id
601: into l_location_id
602: from HZ_LOCATIONS loc, HZ_PARTY_SITES ps
603: where
604: ps.party_id = l_displayed_duns_party_id AND
605: loc.location_id = ps.location_id AND
606: loc.actual_content_source = p_actual_content_source AND

Line 622: from HZ_LOCATIONS loc, HZ_PARTY_SITES ps

618: ELSE -- p_actual_content_source = 'USER_ENTERED'
619: BEGIN
620: select loc.location_id
621: into l_location_id
622: from HZ_LOCATIONS loc, HZ_PARTY_SITES ps
623: where
624: ps.party_id = p_party_id AND
625: loc.location_id = ps.location_id AND
626: loc.actual_content_source = p_actual_content_source AND

Line 636: from HZ_LOCATIONS loc, HZ_PARTY_SITES ps

632:
633: BEGIN
634: select loc.location_id
635: into l_location_id
636: from HZ_LOCATIONS loc, HZ_PARTY_SITES ps
637: where
638: ps.party_id = p_party_id AND
639: loc.location_id = ps.location_id AND
640: loc.actual_content_source = p_actual_content_source AND

Line 645: from hz_locations l_temp, hz_party_sites ps_temp

641: nvl(ps.end_date_active, sysdate+1) >= sysdate AND
642: ps.status = 'A' AND
643: Loc.last_update_date =
644: (select max(l_temp.last_update_date)
645: from hz_locations l_temp, hz_party_sites ps_temp
646: where l_temp.location_id = ps_temp.location_id AND
647: ps_temp.party_id = p_party_id AND
648: l_temp.actual_content_source = p_actual_content_source AND
649: nvl(ps_temp.end_date_active, sysdate+1) >= sysdate AND

Line 674: from HZ_LOCATIONS loc, HZ_PARTY_SITES ps

670: END IF;
671:
672: select loc.location_id
673: into l_location_id
674: from HZ_LOCATIONS loc, HZ_PARTY_SITES ps
675: where ps.party_id = l_displayed_duns_party_id AND
676: loc.location_id = ps.location_id AND
677: loc.actual_content_source = 'DNB' AND
678: nvl(ps.end_date_active, sysdate+1) >= sysdate AND