APPS.JG_ZZ_COMMON_PKG dependencies on HZ_PARTIES

Line 278: ,hz_parties HP

274: ,HL.region_1
275: FROM xle_registrations XR
276: ,xle_entity_profiles XEP
277: ,hr_locations_all HL
278: ,hz_parties HP
279: ,fnd_territories_vl FT
280: WHERE XR.source_id = XEP.legal_entity_id
281: AND XR.source_table = 'XLE_ENTITY_PROFILES'
282: AND XEP.legal_entity_id = pn_legal_entity_id

Line 294: AND HCP.owner_table_name = 'HZ_PARTIES'

290: /*CURSOR lc_contact_phone(cp_party_id in number) IS
291: SELECT HCP.phone_number
292: FROM hz_contact_points HCP
293: WHERE HCP.owner_table_id = cp_party_id
294: AND HCP.owner_table_name = 'HZ_PARTIES'
295: AND HCP.primary_flag = 'Y'
296: AND HCP.contact_point_type= 'PHONE'
297: AND HCP.status = 'A';*/
298: /*

Line 306: FROM HZ_PARTIES HP

302: */
303: CURSOR lc_contact_phone(cp_party_id in number) IS
304: SELECT per.party_name
305: ,per.primary_phone_number
306: FROM HZ_PARTIES HP
307: ,HZ_RELATIONSHIPS REL
308: ,HZ_PARTIES PER
309: WHERE HP.PARTY_ID = cp_party_id
310: AND rel.object_id = HP.PARTY_ID

Line 308: ,HZ_PARTIES PER

304: SELECT per.party_name
305: ,per.primary_phone_number
306: FROM HZ_PARTIES HP
307: ,HZ_RELATIONSHIPS REL
308: ,HZ_PARTIES PER
309: WHERE HP.PARTY_ID = cp_party_id
310: AND rel.object_id = HP.PARTY_ID
311: AND rel.subject_id = per.party_id
312: AND rel.relationship_code = 'CONTACT_OF'

Line 315: AND rel.subject_table_name = 'HZ_PARTIES'

311: AND rel.subject_id = per.party_id
312: AND rel.relationship_code = 'CONTACT_OF'
313: AND rel.relationship_type = 'CONTACT'
314: AND rel.directional_flag = 'F'
315: AND rel.subject_table_name = 'HZ_PARTIES'
316: AND rel.subject_type = 'PERSON'
317: AND rel.object_table_name = 'HZ_PARTIES'
318: AND Trunc(Nvl(rel.end_date, SYSDATE)) > TRUNC(SYSDATE);
319:

Line 317: AND rel.object_table_name = 'HZ_PARTIES'

313: AND rel.relationship_type = 'CONTACT'
314: AND rel.directional_flag = 'F'
315: AND rel.subject_table_name = 'HZ_PARTIES'
316: AND rel.subject_type = 'PERSON'
317: AND rel.object_table_name = 'HZ_PARTIES'
318: AND Trunc(Nvl(rel.end_date, SYSDATE)) > TRUNC(SYSDATE);
319:
320: /* Added for GLOBE-006 ER*/
321: CURSOR lc_commercial_num IS

Line 330: ln_party_id HZ_PARTIES.party_id%TYPE;

326: AND xler.source_id = xlee.LEGAL_ENTITY_ID
327: AND xler.source_TABLE = 'XLE_ENTITY_PROFILES'
328: and xlee.legal_entity_id = pn_legal_entity_id;
329:
330: ln_party_id HZ_PARTIES.party_id%TYPE;
331:
332: BEGIN
333:
334: if gv_debug_flag then