APPS.ASO_PUBLISH_MISC_INT dependencies on HZ_RELATIONSHIPS

Line 958: from hz_relationships l,hz_parties p

954:
955:
956: Cursor c_b2b_contact(pPartyId Number) IS
957: Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type
958: from hz_relationships l,hz_parties p
959: where l.party_id = pPartyId
960: and l.subject_id = p.party_id
961: and l.subject_type = 'PERSON'
962: and l.subject_table_name = 'HZ_PARTIES';

Line 1005: from hz_relationships l,hz_parties p

1001: l_order_id number;
1002:
1003: Cursor c_b2b_contact(pPartyId Number) IS
1004: Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type
1005: from hz_relationships l,hz_parties p
1006: where l.party_id = pPartyId
1007: and l.subject_id = p.party_id
1008: and l.subject_type = 'PERSON'
1009: and l.subject_table_name = 'HZ_PARTIES';

Line 1050: from hz_relationships l,hz_parties p

1046: l_person_title HZ_PARTIES.PERSON_TITLE%TYPE;
1047:
1048: Cursor c_b2b_contact(pPartyId Number) IS
1049: 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
1050: from hz_relationships l,hz_parties p
1051: where l.party_id = pPartyId
1052: and l.subject_id = p.party_id
1053: and l.subject_table_name = 'HZ_PARTIES'
1054: and l.subject_type = 'PERSON';

Line 1368: from hz_relationships l,hz_parties p

1364: AND nvl(status,'A') = 'A';
1365:
1366: Cursor C_B2b_Contact(l_party_id Number) IS
1367: Select p.party_id Person_Party_id
1368: from hz_relationships l,hz_parties p
1369: where l.party_id = l_party_id
1370: and l.subject_id = p.party_id
1371: and l.subject_table_name = 'HZ_PARTIES'
1372: and l.subject_type = 'PERSON';