DBA Data[Home] [Help]

APPS.HZ_DSS_UTIL_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 1621: FROM hz_code_assignments

1617: p_class_category VARCHAR2,
1618: p_class_code VARCHAR2
1619: ) IS
1620: SELECT 1
1621: FROM hz_code_assignments
1622: WHERE owner_table_name = 'HZ_PARTIES'
1623: AND owner_table_id = p_party_id
1624: AND class_category = p_class_category
1625: AND class_code = p_class_code

Line 2144: FROM hz_code_assignments, hz_parties p

2140: CURSOR c_code_assignment (
2141: p_code_assignment_id NUMBER
2142: ) IS
2143: SELECT p.party_id, p.party_type
2144: FROM hz_code_assignments, hz_parties p
2145: WHERE code_assignment_id = p_code_assignment_id
2146: AND owner_table_name = 'HZ_PARTIES'
2147: AND owner_table_id = p.party_id;
2148:

Line 2205: ELSIF p_db_object_name = 'HZ_CODE_ASSIGNMENTS' THEN

2201: OPEN c_location(TO_NUMBER(p_object_pk1));
2202: FETCH c_location BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2203: CLOSE c_location;
2204:
2205: ELSIF p_db_object_name = 'HZ_CODE_ASSIGNMENTS' 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: