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_CODE_ASSIGNMENTS

Line 159: from hz_code_assignments

155: and concat_class_code = p_fsc_rec.condition_value;
156:
157: cursor c_party_category is
158: select 'ALLOCATED',start_date_active,end_date_active
159: from hz_code_assignments
160: where class_category = l_tca_class_category_code
161: and class_code = l_class_code
162: and owner_table_name = l_table_owner
163: and owner_table_id = l_table_id

Line 170: from hz_code_assignments

166: -- Begin Bug Fix 5528805
167:
168: cursor c_party_category_multi_level is
169: select 'ALLOCATED',start_date_active,end_date_active
170: from hz_code_assignments
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)

Line 186: from hz_code_assignments

182: -- End Bug Fix 5528805
183:
184: cursor c_pty_fc_assgn_exists is
185: select 'EXISTS'
186: from hz_code_assignments
187: where class_category = l_tca_class_category_code
188: and owner_table_name = l_table_owner
189: and owner_table_id = l_table_id
190: and p_fsc_rec.tax_determine_date between start_date_active and nvl(end_date_active,p_fsc_rec.tax_determine_date)