DBA Data[Home] [Help]

APPS.ECX_CODE_CONVERSION_PVT dependencies on ECX_XREF_DTL

Line 109: FROM ecx_xref_dtl

105: IF p_tbl(i).xref_category_id IS NOT NULL THEN
106: BEGIN
107: SELECT xref_ext_value
108: INTO l_ext_val
109: FROM ecx_xref_dtl
110: WHERE tp_header_id = p_tp_id AND
111: xref_int_value = p_tbl(i).value AND
112: standard_id = l_standard_id AND
113: xref_category_id = p_tbl(i).xref_category_id AND

Line 306: FROM ecx_xref_dtl

302: ELSIF p_apps_tbl(j).xref_category_id IS NOT NULL THEN
303: BEGIN
304: SELECT xref_int_value
305: INTO l_int_val
306: FROM ecx_xref_dtl
307: WHERE tp_header_id = p_tp_id AND
308: standard_id = p_standard_id AND
309: xref_category_id = p_apps_tbl(j).xref_category_id AND
310: xref_ext_value = p_apps_tbl(j).value AND

Line 475: FROM ecx_xref_dtl

471: /* Bug 2110362
472: Replaced reference to p_standard_id with l_standard_id. */
473: SELECT xref_int_value
474: INTO l_int_val
475: FROM ecx_xref_dtl
476: WHERE tp_header_id = p_snd_tp_id AND
477: standard_id = l_standard_id AND
478: xref_category_id = p_category_id AND
479: xref_ext_value = p_value AND

Line 535: FROM ecx_xref_dtl

531: Replaced reference to p_standard_id with
532: l_standard_id. */
533: SELECT xref_ext_value
534: INTO l_ext_val
535: FROM ecx_xref_dtl
536: WHERE tp_header_id = p_rec_tp_id AND
537: standard_id = l_standard_id AND
538: xref_category_id = p_category_id AND
539: xref_int_value = l_int_val AND

Line 674: FROM ecx_xref_dtl

670: /* Bug 2110362
671: Replaced reference to i_standard_id with l_standard_id. */
672: SELECT xref_int_value
673: INTO l_int_val
674: FROM ecx_xref_dtl
675: WHERE tp_header_id = i_snd_tp_id
676: AND standard_id = l_standard_id
677: AND xref_category_id = i_category_id
678: AND xref_ext_value = io_value

Line 728: FROM ecx_xref_dtl

724: Replaced reference to i_standard_id with
725: l_standard_id. */
726: SELECT xref_ext_value
727: INTO l_ext_val
728: FROM ecx_xref_dtl
729: WHERE tp_header_id = i_rec_tp_id
730: AND standard_id = l_standard_id
731: AND xref_category_id = i_category_id
732: AND xref_int_value = l_int_val