APPS.HZ_UTILITY_V2PUB dependencies on HZ_RELATIONSHIP_TYPES

Line 402: -- column value for hz_relationship_types records.

398: l_return := FALSE;
399: END IF;
400:
401: -- added the following section for caching of incl_unrelated_entities
402: -- column value for hz_relationship_types records.
403: ELSIF p_category = 'RELATIONSHIP_TYPE' THEN
404:
405: l_position1 := INSTRB( p_val, G_SPECIAL_STRING, 1, 1 );
406: l_relationship_type := SUBSTRB( p_val, 1, l_position1 - 1 );

Line 410: FROM HZ_RELATIONSHIP_TYPES

406: l_relationship_type := SUBSTRB( p_val, 1, l_position1 - 1 );
407:
408: BEGIN
409: SELECT INCL_UNRELATED_ENTITIES INTO l_dummy
410: FROM HZ_RELATIONSHIP_TYPES
411: WHERE RELATIONSHIP_TYPE = l_relationship_type
412: AND ROWNUM = 1;
413:
414: IF l_dummy = 'Y' THEN

Line 3216: WHERE c.owner_table_name = 'HZ_RELATIONSHIP_TYPES'

3212:
3213: CURSOR c_groups IS
3214: SELECT null
3215: FROM hz_code_assignments c
3216: WHERE c.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
3217: AND c.class_category = 'RELATIONSHIP_TYPE_GROUP'
3218: AND c.class_code = p_relationship_group_code
3219: AND sysdate between c.start_date_active and nvl(c.end_date_active, sysdate+1)
3220: AND c.status = 'A'