APPS.PV_SQL_UTILITY dependencies on HZ_PARTIES

Line 448: hz_parties b

444: END IF;
445:
446: FOR x IN (SELECT PERSON_LAST_NAME || ' ' || PERSON_FIRST_NAME meaning
447: FROM hz_relationships a,
448: hz_parties b
449: WHERE a.party_id = p_party_id AND
450: a.subject_type = 'PERSON' AND
451: a.subject_id = b.party_id)
452: LOOP

Line 488: hz_parties b

484: END IF;
485:
486: FOR x IN (SELECT email_address meaning
487: FROM hz_relationships a,
488: hz_parties b
489: WHERE a.party_id = p_party_id AND
490: a.subject_type = 'PERSON' AND
491: a.subject_id = b.party_id)
492: LOOP

Line 530: WHERE owner_table_name = 'HZ_PARTIES' AND

526:
527: FOR x IN (SELECT PHONE_COUNTRY_CODE || PHONE_AREA_CODE || PHONE_NUMBER ||
528: PHONE_EXTENSION meaning
529: FROM hz_contact_points
530: WHERE owner_table_name = 'HZ_PARTIES' AND
531: owner_table_id = p_party_id AND
532: contact_point_type = 'PHONE' AND
533: primary_flag = 'Y' AND
534: status = 'A')

Line 573: hz_parties b,

569: END IF;
570:
571: FOR x IN (SELECT PERSON_LAST_NAME || ' ' || PERSON_FIRST_NAME meaning
572: FROM hz_relationships a,
573: hz_parties b,
574: as_lead_contacts_all aslc
575: WHERE aslc.lead_id = p_lead_id AND
576: aslc.primary_contact_flag = 'Y' AND
577: a.party_id = aslc.contact_party_id AND

Line 617: hz_parties b,

613: END IF;
614:
615: FOR x IN (SELECT email_address meaning
616: FROM hz_relationships a,
617: hz_parties b,
618: as_lead_contacts_all aslc
619: WHERE aslc.lead_id = p_lead_id AND
620: aslc.primary_contact_flag = 'Y' AND
621: a.party_id = aslc.contact_party_id AND

Line 665: owner_table_name = 'HZ_PARTIES' AND

661: FROM hz_contact_points,
662: as_lead_contacts_all aslc
663: WHERE aslc.lead_id = p_lead_id AND
664: aslc.primary_contact_flag = 'Y' AND
665: owner_table_name = 'HZ_PARTIES' AND
666: owner_table_id = aslc.contact_party_id AND
667: contact_point_type = 'PHONE')
668: LOOP
669: l_meaning := x.meaning;