APPS.PV_SQL_UTILITY dependencies on HZ_RELATIONSHIPS

Line 447: FROM hz_relationships a,

443: RETURN NULL;
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)

Line 487: FROM hz_relationships a,

483: RETURN NULL;
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)

Line 572: FROM hz_relationships a,

568: RETURN NULL;
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

Line 616: FROM hz_relationships a,

612: RETURN NULL;
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