DBA Data[Home] [Help]

APPS.HZ_UTILITY_V2PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 3231: FROM hz_code_assignments c

3227: ) RETURN VARCHAR2 IS
3228:
3229: CURSOR c_groups IS
3230: SELECT null
3231: FROM hz_code_assignments c
3232: WHERE c.owner_table_name = 'HZ_RELATIONSHIP_TYPES'
3233: AND c.class_category = 'RELATIONSHIP_TYPE_GROUP'
3234: AND c.class_code = p_relationship_group_code
3235: AND sysdate between c.start_date_active and nvl(c.end_date_active, sysdate+1)