DBA Data[Home] [Help]

APPS.PON_ATTR_MAPPING dependencies on HZ_CLASS_CODE_RELATIONS

Line 89: FROM hz_class_code_relations hccr,

85:
86: CURSOR hz_cursor(x_party_id NUMBER)
87: IS
88: SELECT 'HZ:'|| hccr.class_category || ':' || hccr.class_code AS code
89: FROM hz_class_code_relations hccr,
90: ( SELECT class_category, class_code, owner_table_id
91: FROM hz_code_assignments
92: WHERE owner_table_name = 'HZ_PARTIES'
93: AND owner_table_id = x_party_id