APPS.ASO_PARTY_INT dependencies on HZ_RELATIONSHIPS

Line 516: from hz_relationships

512: l_last_update_date := p_party_rec.LAST_UPDATE_DATE;
513:
514: SELECT last_update_date, relationship_id
515: INTO l_party_rel_last_update_date,l_party_relationship_id
516: from hz_relationships
517: where party_id = p_party_rec.party_id
518: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
519: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
520:

Line 544: FROM HZ_RELATIONSHIPS

540: WHERE PARTY_ID = p_party_rec.party_id;
541:
542: SELECT OBJECT_VERSION_NUMBER
543: INTO l_object_version_number
544: FROM HZ_RELATIONSHIPS
545: WHERE RELATIONSHIP_ID = l_party_relationship_id
546: AND DIRECTIONAL_FLAG = 'F';
547:
548: EXCEPTION

Line 732: hz_relationships

728: FROM dual;
729:
730: CURSOR c_party_rel_rec(l_party_id NUMBER) IS
731: SELECT object_id from
732: hz_relationships
733: where party_id = l_party_id
734: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
735: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
736:

Line 1422: FROM hz_relationships par,

1418: AND role_type = l_role_type;
1419:
1420: CURSOR C_party(l_org_contact_id NUMBER) IS
1421: SELECT par.party_id
1422: FROM hz_relationships par,
1423: hz_org_contacts org
1424: WHERE org.party_relationship_id = par.relationship_id
1425: AND org.org_contact_id = l_org_contact_id
1426: and par.subject_type = 'PERSON'

Line 1627: FROM hz_org_contacts oc, hz_parties p, hz_relationships pr

1623: l_api_name CONSTANT VARCHAR2(45) := 'Create_ORG_CONTACT_ORD';
1624:
1625: Cursor C_org_contact (l_party_id NUMBER, l_header_party_id NUMBER) IS
1626: SELECT OC.org_contact_id
1627: FROM hz_org_contacts oc, hz_parties p, hz_relationships pr
1628: WHERE p.party_id = l_party_id
1629: AND p.party_id = pr.subject_id
1630: AND pr.object_id = l_header_party_id
1631: AND (pr.relationship_type = 'CONTACT'

Line 2101: hz_relationships

2097: FROM dual;
2098:
2099: CURSOR c_party_rel_rec(l_party_id NUMBER) IS
2100: SELECT object_id from
2101: hz_relationships
2102: where party_id = l_party_id
2103: and object_table_name = 'HZ_PARTIES'
2104: and subject_type = 'PERSON'
2105: and subject_table_name = 'HZ_PARTIES';