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.ZX_TCM_CONTROL_PKG dependencies on HZ_CLASS_CODE_DENORM

Line 153: from hz_class_code_denorm

149: where party_tax_profile_id = p_fsc_rec.classified_entity_id;
150:
151: cursor c_class_code is
152: select class_code
153: from hz_class_code_denorm
154: where class_category = l_tca_class_category_code
155: and concat_class_code = p_fsc_rec.condition_value;
156:
157: cursor c_party_category is

Line 175: and class_code in (select class_code from hz_class_code_denorm

171: where class_category = l_tca_class_category_code
172: and owner_table_name = l_table_owner
173: and owner_table_id = l_table_id
174: and p_fsc_rec.tax_determine_date between start_date_active and nvl(end_date_active,p_fsc_rec.tax_determine_date)
175: and class_code in (select class_code from hz_class_code_denorm
176: where class_category = l_tca_class_category_code
177: and SUBSTR(concat_class_code , 0, LENGTH(p_fsc_rec.condition_value)) = p_fsc_rec.condition_value
178: );
179: