DBA Data[Home] [Help]

APPS.PV_ORDER_MGMT_PVT dependencies on HZ_PARTY_SITES

Line 437: from hz_party_sites

433: END IF;
434:
435: select party_id
436: into l_party_id
437: from hz_party_sites
438: where party_site_id = p_party_site_id
439: and party_id in (p_partner_party_id, p_contact_party_id)
440: and status = 'A';
441:

Line 1759: from hz_party_sites

1755: BEGIN
1756:
1757: select party_site_id
1758: into x_party_site_id
1759: from hz_party_sites
1760: where party_id = p_contact_party_id
1761: and location_id = p_location_id
1762: and status = 'A';
1763:

Line 2042: hz_party_sites hzs

2038: hzs.location_id
2039: into l_party_type,
2040: l_location_id
2041: from hz_parties hzp,
2042: hz_party_sites hzs
2043: where hzs.party_site_id = p_payment_method_rec.cc_stmt_party_site_id
2044: and hzp.party_id = hzs.party_id;
2045:
2046: IF (PV_DEBUG_HIGH_ON) THEN