APPS.HZ_DSS_UTIL_PUB dependencies on HZ_RELATIONSHIPS

Line 622: l_db_object_name := 'HZ_RELATIONSHIPS';

618: -- check relationship.
619: --
620: IF p_db_object_name = 'HZ_PARTIES' THEN
621: IF is_relationship_party(TO_NUMBER(p_object_pk1), l_relationship_id) = 'Y' THEN
622: l_db_object_name := 'HZ_RELATIONSHIPS';
623: l_object_pk1 := l_relationship_id;
624: l_object_pk2 := 'F';
625: END IF;
626: END IF;

Line 1819: FROM hz_relationships rel

1815: ,p_relationship_id NUMBER -- Bug 5687869 (Nishant)
1816: ) IS
1817: -- SELECT 1
1818: SELECT rel.relationship_type -- changed so that it is easy to debug
1819: FROM hz_relationships rel
1820: WHERE rel.subject_id = p_party_id AND
1821: rel.subject_table_name = 'HZ_PARTIES'
1822: AND rel.relationship_id = p_relationship_id -- added for Bug 5687869
1823: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (

Line 1931: FROM hz_relationships rel

1927: p_dss_group_code VARCHAR2
1928: ) IS
1929: -- SELECT 1 (Bug 5687869)
1930: SELECT rel.relationship_type
1931: FROM hz_relationships rel
1932: WHERE rel.party_id = p_party_id
1933: AND rel.relationship_id = p_object_pk1 --(Bug 5687869)
1934: AND (rel.relationship_type, rel.relationship_code, rel.subject_type, rel.object_type) IN (
1935: SELECT relationship_type, forward_rel_code,

Line 2050: FROM hz_relationships

2046: CURSOR c_relationship_party (
2047: p_party_id NUMBER
2048: ) IS
2049: SELECT relationship_id
2050: FROM hz_relationships
2051: WHERE party_id = p_party_id
2052: AND directional_flag = 'F';
2053:
2054: l_party_type VARCHAR2(30);

Line 2155: FROM hz_relationships

2151: p_directional_flag VARCHAR2
2152: ) IS
2153: SELECT subject_id, subject_table_name, subject_type,
2154: object_id, object_table_name, object_type
2155: FROM hz_relationships
2156: WHERE relationship_id = p_relationship_id
2157: AND directional_flag = p_directional_flag
2158: AND (subject_table_name = 'HZ_PARTIES' OR
2159: object_table_name = 'HZ_PARTIES');

Line 2210: ELSIF p_db_object_name = 'HZ_RELATIONSHIPS' THEN

2206: OPEN c_code_assignment(TO_NUMBER(p_object_pk1));
2207: FETCH c_code_assignment BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2208: CLOSE c_code_assignment;
2209:
2210: ELSIF p_db_object_name = 'HZ_RELATIONSHIPS' THEN
2211: OPEN c_relationship(TO_NUMBER(p_object_pk1), p_object_pk2);
2212: FETCH c_relationship INTO
2213: l_subject_id, l_subject_table_name, l_subject_type,
2214: l_object_id, l_object_table_name, l_object_type;