APPS.JTF_TERR_NA_MERGE_PUB dependencies on HZ_PARTY_SITES

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 74: HZ_PARTY_SITES H2

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
77: AND h3.party_id = p_party_id
78: AND h2.party_site_id = p_party_site_id;

Line 260: IF ( p_entity_name <> 'JTF_TTY_NAMED_ACCTS' OR p_parent_entity_name <> 'HZ_PARTY_SITES' ) THEN

256: END IF;
257:
258: x_return_status := fnd_api.g_ret_sts_success;
259:
260: IF ( p_entity_name <> 'JTF_TTY_NAMED_ACCTS' OR p_parent_entity_name <> 'HZ_PARTY_SITES' ) THEN
261: FND_FILE.PUT_LINE(FND_FILE.LOG,' Entity error');
262: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
263: fnd_message.set_token('P_ENTITY',p_entity_name);
264: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

Line 310: FROM hz_party_sites hzps

306: p_from_party := get_party_name(p_from_fk_id);
307:
308: SELECT hzps.party_id
309: INTO l_from_party_id
310: FROM hz_party_sites hzps
311: WHERE hzps.party_site_id = p_from_fk_id
312: AND rownum < 2;
313:
314: END IF;

Line 322: FROM hz_party_sites hzps

318: p_to_party := get_party_name(p_to_fk_id);
319:
320: SELECT hzps.party_id
321: INTO l_to_party_id
322: FROM hz_party_sites hzps
323: WHERE hzps.party_site_id = p_to_fk_id
324: AND rownum < 2;
325:
326: END IF;

Line 451: FROM hz_party_sites hzps

447:
448: BEGIN
449: SELECT hzps.party_id
450: INTO l_to_party_id
451: FROM hz_party_sites hzps
452: WHERE hzps.party_site_id = p_to_fk_id
453: AND rownum < 2;
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN