DBA Data[Home] [Help]

APPS.ECE_RULES_PKG dependencies on HR_LOCATIONS

Line 422: hr_locations hrl

418: CURSOR c_hr_addr IS
419: select td.tp_detail_id,
420: nvl(td.edi_flag,'N')
421: from ece_tp_details td,
422: hr_locations hrl
423: where td.translator_code = l_translator_code and
424: hrl.ece_tp_location_code = l_location_code and
425: hrl.tp_header_id = td.tp_header_id and
426: td.document_id = p_transaction_type and

Line 2315: -- inventory_organization_id from hr_locations.

2311: end if;
2312:
2313: -- Bug 2570369: Uncommented the following if condition because the x_tp_translator_code
2314: -- is used as a placeholder to store new values from the AD code such as
2315: -- inventory_organization_id from hr_locations.
2316:
2317: if (p_tp_translator_code_pos is not null) and (x_tp_translator_code is not null) then
2318: xProgress := 'ECERULEB-130-1290';
2319: ec_utils.g_file_tbl (p_tp_translator_code_pos).value := x_tp_translator_code;