eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_DSS_UTIL_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 1629: FROM hz_code_assignments

1625: p_class_category VARCHAR2,
1626: p_class_code VARCHAR2
1627: ) IS
1628: SELECT 1
1629: FROM hz_code_assignments
1630: WHERE owner_table_name = 'HZ_PARTIES'
1631: AND owner_table_id = p_party_id
1632: AND class_category = p_class_category
1633: AND class_code = p_class_code

Line 2284: FROM hz_code_assignments, hz_parties p

2280: CURSOR c_code_assignment (
2281: p_code_assignment_id NUMBER
2282: ) IS
2283: SELECT p.party_id, p.party_type
2284: FROM hz_code_assignments, hz_parties p
2285: WHERE code_assignment_id = p_code_assignment_id
2286: AND owner_table_name = 'HZ_PARTIES'
2287: AND owner_table_id = p.party_id;
2288:

Line 2345: ELSIF p_db_object_name = 'HZ_CODE_ASSIGNMENTS' THEN

2341: OPEN c_location(TO_NUMBER(p_object_pk1));
2342: FETCH c_location BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2343: CLOSE c_location;
2344:
2345: ELSIF p_db_object_name = 'HZ_CODE_ASSIGNMENTS' THEN
2346: OPEN c_code_assignment(TO_NUMBER(p_object_pk1));
2347: FETCH c_code_assignment BULK COLLECT INTO x_party_id_tbl, x_party_type_tbl;
2348: CLOSE c_code_assignment;
2349: