APPS.JTF_TERR_NA_MERGE_PUB dependencies on HZ_PARTIES

Line 34: from hz_parties hzp, hz_party_sites hzps

30: p_party_name VARCHAR2(80);
31: BEGIN
32: select hzp.party_name
33: into p_party_name
34: from hz_parties hzp, hz_party_sites hzps
35: where hzp.party_id = hzps.party_id
36: and hzps.party_site_id = p_party_site_id;
37:
38: return p_party_name;

Line 72: FROM HZ_PARTIES H3,

68: H1.postal_code
69: INTO p_business_name,
70: p_trade_name,
71: p_postal_code
72: FROM HZ_PARTIES H3,
73: HZ_LOCATIONS H1,
74: HZ_PARTY_SITES H2
75: WHERE h3.party_id = h2.party_id
76: AND h2.location_id = h1.location_id