APPS.JG_ZZ_COMMON_PKG dependencies on HZ_PARTIES

Line 289: ,hz_parties HP

285: ,HL.region_1
286: FROM xle_registrations XR
287: ,xle_entity_profiles XEP
288: ,hr_locations_all HL
289: ,hz_parties HP
290: ,fnd_territories_vl FT
291: WHERE XR.source_id = XEP.legal_entity_id
292: AND XR.source_table = 'XLE_ENTITY_PROFILES'
293: AND XEP.legal_entity_id = pn_legal_entity_id

Line 305: AND HCP.owner_table_name = 'HZ_PARTIES'

301: /*CURSOR lc_contact_phone(cp_party_id in number) IS
302: SELECT HCP.phone_number
303: FROM hz_contact_points HCP
304: WHERE HCP.owner_table_id = cp_party_id
305: AND HCP.owner_table_name = 'HZ_PARTIES'
306: AND HCP.primary_flag = 'Y'
307: AND HCP.contact_point_type= 'PHONE'
308: AND HCP.status = 'A';*/
309: /*

Line 317: FROM HZ_PARTIES HP

313: */
314: CURSOR lc_contact_phone(cp_party_id in number) IS
315: SELECT per.party_name
316: ,per.primary_phone_number
317: FROM HZ_PARTIES HP
318: ,HZ_RELATIONSHIPS REL
319: ,HZ_PARTIES PER
320: WHERE HP.PARTY_ID = cp_party_id
321: AND rel.object_id = HP.PARTY_ID

Line 319: ,HZ_PARTIES PER

315: SELECT per.party_name
316: ,per.primary_phone_number
317: FROM HZ_PARTIES HP
318: ,HZ_RELATIONSHIPS REL
319: ,HZ_PARTIES PER
320: WHERE HP.PARTY_ID = cp_party_id
321: AND rel.object_id = HP.PARTY_ID
322: AND rel.subject_id = per.party_id
323: AND rel.relationship_code = 'CONTACT_OF'

Line 326: AND rel.subject_table_name = 'HZ_PARTIES'

322: AND rel.subject_id = per.party_id
323: AND rel.relationship_code = 'CONTACT_OF'
324: AND rel.relationship_type = 'CONTACT'
325: AND rel.directional_flag = 'F'
326: AND rel.subject_table_name = 'HZ_PARTIES'
327: AND rel.subject_type = 'PERSON'
328: AND rel.object_table_name = 'HZ_PARTIES'
329: AND Trunc(Nvl(rel.end_date, SYSDATE)) > TRUNC(SYSDATE);
330:

Line 328: AND rel.object_table_name = 'HZ_PARTIES'

324: AND rel.relationship_type = 'CONTACT'
325: AND rel.directional_flag = 'F'
326: AND rel.subject_table_name = 'HZ_PARTIES'
327: AND rel.subject_type = 'PERSON'
328: AND rel.object_table_name = 'HZ_PARTIES'
329: AND Trunc(Nvl(rel.end_date, SYSDATE)) > TRUNC(SYSDATE);
330:
331: /* Added for GLOBE-006 ER*/
332: CURSOR lc_commercial_num IS

Line 341: ln_party_id HZ_PARTIES.party_id%TYPE;

337: AND xler.source_id = xlee.LEGAL_ENTITY_ID
338: AND xler.source_TABLE = 'XLE_ENTITY_PROFILES'
339: and xlee.legal_entity_id = pn_legal_entity_id;
340:
341: ln_party_id HZ_PARTIES.party_id%TYPE;
342:
343: BEGIN
344:
345: if gv_debug_flag then