DBA Data[Home] [Help]

APPS.JTF_RS_PARTY_MERGE_PUB dependencies on HZ_PARTY_SITES

Line 68: hz_party_sites prt

64: is
65: SELECT par.party_type,
66: prt.party_site_id address_id
67: FROM hz_parties par,
68: hz_party_sites prt
69: WHERE par.party_id = l_party_id
70: AND par.party_id = prt.party_id(+)
71: AND nvl(prt.identifying_address_flag, 'Y') = 'Y'
72: AND nvl(prt.status, 'A') = 'A';

Line 79: from hz_party_sites prt

75:
76: cursor party_addr_cur(l_party_id in number)
77: is
78: select prt.party_site_id address_id
79: from hz_party_sites prt
80: where prt.party_id = l_party_id
81: and prt.identifying_address_flag = 'Y'
82: and prt.status = 'A';
83:

Line 548: or (p_parent_entity_name <> 'HZ_PARTY_SITES')

544:
545: x_return_status := fnd_api.g_ret_sts_success;
546:
547: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
548: or (p_parent_entity_name <> 'HZ_PARTY_SITES')
549: then
550: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
551: fnd_message.set_token('P_ENTITY',p_entity_name);
552: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

Line 971: HZ_PARTY_SITES PARTY_SITE,

967: FROM
968: HZ_PARTIES PARTY,
969: HZ_PARTIES PARTY2,
970: HZ_PARTIES PARTY3,
971: HZ_PARTY_SITES PARTY_SITE,
972: HZ_LOCATIONS LOC,
973: HZ_CONTACT_POINTS CT_POINT1,
974: -- HZ_PARTY_RELATIONSHIPS REL
975: HZ_RELATIONSHIPS REL

Line 1187: --from hz_party_sites p,

1183:
1184: --cursor support_site_cur(c_support_site_id number)
1185: --is
1186: --select 'X'
1187: --from hz_party_sites p,
1188: -- hz_party_site_uses psu
1189: --where p.party_site_id = psu.party_site_id
1190: --and psu.site_use_type = 'SUPPORT_SITE'
1191: --and p.party_site_id = c_support_site_id;

Line 1219: or (p_parent_entity_name <> 'HZ_PARTY_SITES')

1215: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1216: l_login_id := NVL(FND_PROFILE.Value('LOGIN_ID'), -1);
1217:
1218: if (p_entity_name <> 'JTF_RS_RESOURCE_EXTNS')
1219: or (p_parent_entity_name <> 'HZ_PARTY_SITES')
1220: then
1221: fnd_message.set_name ('JTF', 'JTF_RS_ENTITY_NAME_ERR');
1222: fnd_message.set_token('P_ENTITY',p_entity_name);
1223: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);