APPS.ASO_PUBLISH_MISC_INT dependencies on HZ_RELATIONSHIPS

Line 927: from hz_relationships l,hz_parties p

923:
924:
925: Cursor c_b2b_contact(pPartyId Number) IS
926: Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type
927: from hz_relationships l,hz_parties p
928: where l.party_id = pPartyId
929: and l.subject_id = p.party_id
930: and l.subject_type = 'PERSON'
931: and l.subject_table_name = 'HZ_PARTIES';

Line 974: from hz_relationships l,hz_parties p

970: l_order_id number;
971:
972: Cursor c_b2b_contact(pPartyId Number) IS
973: Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type
974: from hz_relationships l,hz_parties p
975: where l.party_id = pPartyId
976: and l.subject_id = p.party_id
977: and l.subject_type = 'PERSON'
978: and l.subject_table_name = 'HZ_PARTIES';

Line 1019: from hz_relationships l,hz_parties p

1015: l_person_title HZ_PARTIES.PERSON_TITLE%TYPE;
1016:
1017: Cursor c_b2b_contact(pPartyId Number) IS
1018: Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type,p.person_title
1019: from hz_relationships l,hz_parties p
1020: where l.party_id = pPartyId
1021: and l.subject_id = p.party_id
1022: and l.subject_table_name = 'HZ_PARTIES'
1023: and l.subject_type = 'PERSON';

Line 1337: from hz_relationships l,hz_parties p

1333: AND nvl(status,'A') = 'A';
1334:
1335: Cursor C_B2b_Contact(l_party_id Number) IS
1336: Select p.party_id Person_Party_id
1337: from hz_relationships l,hz_parties p
1338: where l.party_id = l_party_id
1339: and l.subject_id = p.party_id
1340: and l.subject_table_name = 'HZ_PARTIES'
1341: and l.subject_type = 'PERSON';