APPS.ECX_XREF_API dependencies on ECX_STANDARDS

Line 258: ECX_STANDARDS es

254: into x_xref_dtl_id,
255: x_xref_ext_value
256: from ECX_XREF_HDR exh,
257: ECX_XREF_DTL exd,
258: ECX_STANDARDS es
259: where exh.xref_category_code = p_xref_category_code
260: and exh.xref_category_id = exd.xref_category_id
261: and exd.direction = 'OUT'
262: and exd.xref_int_value = p_xref_int_value

Line 330: ECX_STANDARDS es

326: into x_xref_dtl_id,
327: x_xref_int_value
328: from ECX_XREF_HDR exh,
329: ECX_XREF_DTL exd,
330: ECX_STANDARDS es
331: where exh.xref_category_code = p_xref_category_code
332: and exh.xref_category_id = exd.xref_category_id
333: and exd.direction = 'IN'
334: and exd.xref_ext_value = p_xref_ext_value

Line 423: ECX_STANDARDS es

419: x_creation_date,
420: x_created_by
421: from ECX_XREF_HDR_VL exh,
422: ECX_XREF_DTL_VL exd,
423: ECX_STANDARDS es
424: where exh.xref_category_id = exd.xref_category_id
425: and exd.xref_dtl_id = p_xref_dtl_id
426: and es.standard_id = exd.standard_id;
427: exception

Line 526: ECX_STANDARDS es

522: x_creation_date,
523: x_created_by
524: from ECX_XREF_HDR_VL exh,
525: ECX_XREF_DTL_VL exd,
526: ECX_STANDARDS es
527: where exh.xref_category_code = p_xref_category_code
528: and exh.xref_category_id = exd.xref_category_id
529: and exd.direction = p_direction
530: and exd.xref_ext_value = p_xref_ext_value

Line 634: from ecx_standards

630: end;
631:
632: select standard_id
633: into i_standard_id
634: from ecx_standards
635: where standard_code = p_standard
636: and standard_type = nvl(p_standard_type, 'XML');
637:
638: select ecx_xref_dtl_s.nextval into x_xref_dtl_id from dual;

Line 917: ECX_STANDARDS es

913: x_creation_date,
914: x_created_by
915: from ECX_XREF_HDR_vl exh,
916: ECX_XREF_STANDARDS_vl exs,
917: ECX_STANDARDS es
918: where exh.xref_category_code = p_xref_category_code
919: and exh.xref_category_id = exs.xref_category_id
920: and exs.xref_std_value = p_xref_std_value
921: and exs.xref_int_value = p_xref_int_value

Line 1012: from ecx_standards

1008:
1009: begin
1010: select standard_id
1011: into i_standard_id
1012: from ecx_standards
1013: where standard_code = p_standard
1014: and standard_type = nvl(p_standard_type, 'XML');
1015: exception
1016: when no_data_found then