418: x_last_updated_by,
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;
521: x_last_updated_by,
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