1059: BEGIN
1060: SELECT
1061: p.party_id INTO l_contact_pers_party_id
1062: FROM
1063: hz_relationships rel,
1064: hz_parties p,
1065: hz_parties o,
1066: hz_parties rel_party,
1067: ar_lookups lkup,
1110: BEGIN
1111: SELECT
1112: rel.party_id INTO l_contact_rel_party_id
1113: FROM
1114: hz_relationships rel,
1115: hz_parties p,
1116: hz_parties o,
1117: hz_parties rel_party,
1118: ar_lookups lkup,
2004: BEGIN
2005: SELECT
2006: p.party_id INTO l_contact_pers_party_id
2007: FROM
2008: hz_relationships rel,
2009: hz_parties p,
2010: hz_parties o,
2011: hz_parties rel_party,
2012: ar_lookups lkup,
2055: BEGIN
2056: SELECT
2057: rel.party_id INTO l_contact_rel_party_id
2058: FROM
2059: hz_relationships rel,
2060: hz_parties p,
2061: hz_parties o,
2062: hz_parties rel_party,
2063: ar_lookups lkup,